Insert a picture from an UserForm

**rachelies** · 08-03-2008, 03:47 AM

Sorry for my bad English.
I'm making a UserForm for a coin collection. In this UserForm I want to look for a picture, show it in the userform and then insert it into a cell of my sheet.
¿Can someone help me? Thanks

**Tom Schreiner** · 08-03-2008, 07:28 AM

Hi Rachelies.

"In this UserForm I want to look for a picture..."

What is the source of your pictures? Are they already loaded in the userform? Will you need to browse your hard drive for a picture, load and view it in your userform, and then send it to a range?

What have you developed to this point?

**davesexcel** · 08-03-2008, 07:39 AM

Check out this example on inserting pics
Select the blue cell and pick a picture.

The example is located from this thread

**rachelies** · 08-05-2008, 02:32 PM

Originally Posted by Tom Schreiner

Hi Rachelies.

"In this UserForm I want to look for a picture..."

What is the source of your pictures? Are they already loaded in the userform? Will you need to browse your hard drive for a picture, load and view it in your userform, and then send it to a range?

What have you developed to this point?

I want to do exactly this!!!! Can someone help me to do this? Thanks

**Tom Schreiner** · 08-05-2008, 02:58 PM

Hi Rachelies.

"I'm making a UserForm for a coin collection."

Help you or do it for you? Do you have anything to post? Have you made any attempt on your own? Please post your code or at least an attachment...

**rachelies** · 08-05-2008, 03:17 PM

I know how to make the buttons, save the data into the sheet, but i dont know how to make the picture, so I answer. And I will not begin to make the userform if I don´t know how to make the picure,
I only know a few of excel, but I know much about other materies, and if I could, I would help.

**Tom Schreiner** · 08-05-2008, 05:26 PM

Ok. Add UserForm1 with two commandbuttons named BrowseForFile and SendPictureToRange and Image1. The picture is inserted into the same dimenions as the selected range.

Add the following code...

Please Login or Register  to view this content.

**Leith Ross** · 08-05-2008, 09:20 PM

Hello Tom,

I am not sure why you are using API calls here. The UserForm has both a Show and Hide method.

Sincerely,
Leith Ross

**Tom Schreiner** · 08-05-2008, 09:56 PM

Hi Leith.

If the userform is modeless then using the hide and show methods would be fine.

As it is, you would have to use Me.Show vbModeless or the remainder of the SendPictureToRange_Click procedure would not run. Of course you could throw some instructions in an event procedure but the several API functions are more concise IMO.

The API method will work with a modeless of modal userform.

Is there an easier way to do this that I am missing...?

Thanks -