image

Hi, i'm looking to find the sum of two columns (that are not next to each other) based on the conditions of a third column. I am trying to do a final report of finances based on cost centres (in the third column), and the amounts are in two columns, cash and bank. I'm not sure how to attach...

I add a image as a header and I have white gridlines appearing throughout the image. If I add the image just as an image, it is fine but if added through the insert header, it has the lines through it. How do I get rid of them?

Hello there Excel Experts, I have this html file that has a table consists of 3 rows and 1 column. for each row of each column, there is an image with text descriptions. What I need to do is to be able to export out as an excel file, where the output should be that the image will be attached in...

Hi guys, I'm having some hard time with the following. I have a For - Next loop in Excel that generates an Outlook MailItem drafts with embedded image using ContentID. Dim outApp as Object Dim outMail as Object Set outApp = CreateObject("Outlook.Application") For i '..... blah...

I have made a spreadsheet for my supervisor and he wants the ability to insert a custom signature file at the bottom of a sheet using the browse dialogue box. I already have two buttons that enter a signature each. The signatures are in the right position. Sub cmdJakeSig()...

Hello Folks, I'm new at this so any help appreciated. I have a form that starts on Workbook_Open. It simply displays an image that gets updated form another system. When the user select the Option_Button1, the code should get the picture, wait 5 seconds and then redisplay it. It does work...

Good day, I have a userform with 31 image controls (on for each day of the month of May) which populate with pictures from a folder that are all contain dates (again in May) in the name. I then extract the date from the filename and find the correct image control to place it in. The code...

Hi, Does anyone have some code that can loop through each sheet in the activeworkbook and list all shapes/images and their dimensions / properties? I am most interested in the resolution of the images, but it would be useful to know other info too. Can anyone help? thanks, Mark

I would like to extract the thumbnail.bmp image of this file and putting it in image box https://drive.google.com/file/d/1d4sco69RbSIi2fiNS5l3_8cF7vfZuFE_/view?usp=sharing especially using binary access

Excel VBA is great to read a picture's metadata but it seems tough to have it write any to the file. Ffor a large number of pictures, because it's so much easier to modify the image attributes in Excel than to do it to the pictures individually, I'm looking for a way to take what I write on a...

I want the Value should be Auto Printed Number of Times When Count is Given [My Image 1][1]: https://tinyurl.com/yxlcsypz If you see my image there is Count and Value as some Data like 'DEMO' When i enter count like 5 then the Data in Value = Demo should be printed that many times as Count is...

Sub URLPictureInsert() Dim Pshp As Shape Dim i As Long Dim lastRow As Long Dim urlRng As Range Dim trgtRng As Range lastRow = Range("A" & Rows.Count).End(xlUp).Row For i = 2 To lastRow Set urlRng = Range("B" & i) Set trgtRng = Range("C" & i) If urlRng = ""...

Are you able to place comboboxes over an image? I have an image resembling a trailer and I want comboboxes to be on top of it looking like the selection within the combobox is a certain pallet in that location of the trailer. Possible? I've tried dragging the comboboxes onto the picture and...

Hi All, In the below link of my data, I have to compare the values of the two cells side by side. Now I have to place an arrow(image) for the values in column A which are greater than that of B. https://ibb.co/SmWGk4L Is this possible to automate via VBA? If so, kindly help me on this. I...

Hi Can anyone help with the following problem , the black cells in rows 47-52 appear according to the number in row 46,these are formulas that count the number of 5's in the column above, I would like these cell to be colour formatted eg the first 5 in j16:j36 to appear but be colour formatted...

Hi Guys i have some data i get with two basic columns part number and image link, i need to import these into my site with the first column being the part number and the image link, then the next image link here is one image link ( i did this ) <colgroup><col><col></colgroup><tbody> sku pic...

Hi I have a table with poker combinations achieved on different dates. I need to extract the best dates between two given dates on the second table. https://drive.google.com/open?id=1vWkuzGn3VcZiOE-cYXkjV0VT23kHdQHC Not sure if the image of my screenshot is visible on the post . If not, below...

Hi, I have a list of image file names (minus the extensions) in column A and an Image ActiveX control embedded on Sheet1. Could you help me with a code that would access and display the images? For instance, when a cell in column A containing "Image1" is selected, Excel should access...

[/IMG]Hi Is this possible... I have a group of signatures on a worksheet (images) I would like to select an image and rename it to the name stored in a combobox by pressing a command button. Is there a way of changing the selected image? activeimage? Thanks Mark

I have an image open in a form. The user needs to select a section of the image by drawing a rectangle and zoom to that area. I've got it working with scroll bars and command buttons but it's not elegant. A lot of clicking and sliding. I could do it using Shapes etc but am hoping there is...