Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Photos in a Image Object
I have named a file path and file location in VB to locate a particular
photo. As the user selects different items from a droplist the file path and name change. In the change event on that droplist I need to know how to call the load event for the Image object. So far I have tried: Image1.Picture = LoadPicture(PictureFileName1) - Where PictureFileName is my path and file name as well as hard coding to Image1.Picture = LoadPicture("e:\monthlyreport\Photo1.bmp") I don't understand the correct syntax to change the picture file. Please help. Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Photos in a Image Object
Hi Troubled User,
You have responses to your post in Programming. --- Regards, Norman "Troubled User" wrote in message ... I have named a file path and file location in VB to locate a particular photo. As the user selects different items from a droplist the file path and name change. In the change event on that droplist I need to know how to call the load event for the Image object. So far I have tried: Image1.Picture = LoadPicture(PictureFileName1) - Where PictureFileName is my path and file name as well as hard coding to Image1.Picture = LoadPicture("e:\monthlyreport\Photo1.bmp") I don't understand the correct syntax to change the picture file. Please help. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
Creating a Powerpoint object (in XP onwards) with an ActiveWindow | Excel Discussion (Misc queries) | |||
Aspect ratio of image differs in print | Excel Discussion (Misc queries) | |||
VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) | |||
partial photos in Excel cells | Setting up and Configuration of Excel |