Hello All,
I have done extensive searching all over the internet for what I thought would be a simple answer, but this one is proving to elude me.
This is to load a picture onto an image in a form.
How do I change this line here...(which works)
Image1.Picture = LoadPicture("C:\picture1.jpg")
to instead, say this here...
Image1.Picture = LoadPicture =(WB named "Macros"\WS Named "Sheet1"\picture1.jpg)
I need to load pictures from my macros startup workbook rather than a folder structure because otherwise, this code won't work on another computer.
UPDATE: I tried this and it didn't work..
UF_Status.Image1.Picture = LoadPicture.Sheets("Sheet1").Shapes("Picture1")
Thanks much
Bookmarks