I currently have a macro that pulls a list of Part Numbers that needs to get done for the week. I would like to use another macro to add a picture beside the part number cell to give a little visual of the what the part looks like.
I already have a macro that does this but not how I want it...
I use the following code which works as wanted:
Private Sub CommandButton1_Click()
Dim MyObj As Object
Application.ScreenUpdating = False
myPicture = Application.GetOpenFilename _
("Bilder (*.gif; *.jpg; *.jpeg; *.png; *.bmp; *.tif),*.gif...
I'm having trouble with my macro and I feel like I'm not seeing things clearly anymore, any help is helpful, especially with the idea of looping
1. Prompt user for folder
(I have this done and I stored it as MyDir as a string)
2. Folder contains image files with names that are found in a cell...
Hi Im wondering if anyone can help me with something.
Im looking to insert a picture into my excel sheet based on the contents of an input cell.
so when name in the input cell changes so does the logo/picture.
any help would be much appreciated.
Im currently using the Mr.Excel Picture lookup...
How can I display an image that is referenced in a different worksheet?
For example, sheet1!A1 contains a link to an image file, just a hyperlink to a local jpg. On sheet2, in some arbitrary cell, say B5, I would like to display the image that is referenced in sheet1!A1, i.e. sheet2!B5 shows...
Im new to the board ... I want to post a question with an Image to help explain what I need... however im not sure how to Insert an Image.
The Image is on my desktop in a JPEG ... how do I get an URL of this.
I know its prob simple but Im still learning :biggrin:
Thanks very much
I am putting together a price list in excel and using images and hyperlinks to jazz it up a bit - what I am finding is that if I insert a 25KB GIF image, the excel file grows in size by over 100KB - why is this disproportionate growth happening and is there a way around it - I dont want my Price...