Insert userform image into a worksheet

Dear All,

By clicking CommandButton1, Could any one help me insert an image in Userform1 in some where in the worksheet?

Thanks in advance

Add this code to your UserForm code to handle the button click. This code will create a temporary file based on the picture, insert it to the sheet, then delete the temporary file.

Please Login or Register  to view this content.

Adapted from a solution by Tim Williams

Dear 6StringJazzer,

Thank you for your help. this is exactly what i wanted. can I resize the picture and put it in specific cell, line cell D3:G6?
Thanks again
Ahmed

To put it in a specific cell, use code to Select that cell before the insert.

"put it in specific cell, line cell D3:G6" That is 12 cells, I'm not sure what you are trying to do there.

You can adjust the display size by adjusting the Shape attributes Height and Width after the insert. After the insert it can be referenced as Sheet1.Shapes(Sheet1.Shapes.Count)

Please Login or Register  to view this content.

Thanks dear, its working...

Originally Posted by Menohavename

Hi, this piece of code has helped me a lot and works perfectly. I'm struggling with a follow-up problem though

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread