Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Worksheet picture Control (Excel 2003)

    Hi all,

    I am trying to load a Image Control from a file on a server, the Image Control resides on the Worksheet. I can load a picture on a form without error, but I can not load it to a Image Control on a Spreadsheet, Is there something different than loading it on a form? IS there a thread or can some one give me some direction?

    Thanks,
    Darryl.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Worksheet picture Control (Excel 2003)

    How are you trying to do this? Manually or using code?

    If manually, make sure that design mode is active (first button on the Control Toolbox is "on"). Then right-click the control and select Properties from the popup menu. Click in the Picture property, then click the ... button on the right hand side.

    In code, use an instruction like this:

    Sheet1.Image1.Picture = LoadPicture("serversharefolderpicture.jpg")

    or

    Worksheets("MySheet").OLEObjects("Image1").Object. Picture = LoadPicture("serversharefolderpicture.jpg")

    Of course, you must substitute the correct names. In the first instruction, Sheet1 is the code name (the VBA name) of the worksheet, in the second one, MySheet is the displayed name (the caption of the worksheet tab).

  3. #3
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Worksheet picture Control (Excel 2003)

    Thank you Hans.

Posting Permissions

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