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...
Hi,
I use the following code which works as wanted:
Private Sub CommandButton1_Click()
Dim myPicture
Dim MyObj As Object
Application.ScreenUpdating = False
Sheets("Kumkort").Unprotect
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...
Hi there,
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.