Results 1 to 33 of 33

Form: Load Picture from Worksheet instead of a folder structure

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    04-11-2006
    MS-Off Ver
    2007
    Posts
    438

    Form: Load Picture from Worksheet instead of a folder structure

    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
    Last edited by duugg; 11-18-2011 at 09:05 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1