Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Picture Into Image In UserForm
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").C ells(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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Picture Into Image In UserForm
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. "ZipCurs" wrote: 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").C ells(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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add Userform Image from Cell Picture Address | Excel Programming | |||
image & picture | Excel Programming | |||
Charts to Image or Picture? | Charts and Charting in Excel | |||
Screen flicker when changing Image.Picture source on UserForm | Excel Programming | |||
userform image from picture in worksheet | Excel Programming |