Getting Picture Into Image In UserForm

Z

ZipCurs

I am guessing that this is incredibly easy, but it is beyond me. All I want
to do is click the Image box on the UserForm and be able to select a Picture.

I can very easily get the code to write to a desired cell using
xlDialogInsertPicture, which I like because it ensure that it is an
appropriate object. I can't get the image to show up on the UserForm using:

Image1.Picture=LoadPicture(Sheet("PictureSheet").Cells(1,1).Value)

I can imaging a lot of ways to do this, but a good top level method would be
best. In support of my own ideas:
- Can I get the path from xlDialogInsertPicture?
- Is there a generic pictures filter for GetOpenFilename?
- Can I extract the image from the UserForm and insert it somewhere else
later or is it lost?

Any help is appreciated. Thanks in advance
 
Z

ZipCurs

A little too quick with my question. What I really need to know is whether
there is a good generic FileFilter for images, and if & how I can extract the
image from the UserForm.

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top