Add picture from userform image control to sheet cell as comment vba

You need the image path and file name for the .Comment image. I don't know a way to get that directly from the Image1 control. But when you load an image in the Image1 control, you can store the Path and Filename in the Image1.Tag property

Please Login or Register  to view this content.

Then later, use that .Tag property to retrieve the path and file name for the comment image.

Please Login or Register  to view this content.

Originally Posted by KK1234

Hi AlphaFrog,
First of all thank you for your help.
I have studied your solution , however everytime its a different image.
Is it possible to get path as text to another textbox when picture is loaded and then use this textbox path ( Tag) later in your solution as tag??
Any help please.
K regs
KK1234

When you say it's a different image every time, when you load an image in the Image1 control, simply store the path and file name in the .tag property. So whatever image is in the control, it's path and filename are also there in the .tag property. That's basically the same thing you're asking to do with a separate textbox.

In the example above, I use a fixed image path and file name for the Image1 image. You can use whatever your using now to load the Image1 image. Just add that path and file name to the .Tag property as well.

One can create a BMP file from a picture object without knowing the filename but I prefer AlphaFrog's Tag property method.

I would suggest that you find some way to not use SendKeys().

You're welcome and thinks for the feedback.