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

    image control (Excel 2003)

    Hi all,

    I have been trying to figure out a problem that I am having with a worksheet image control.

    The problem is, I have a form, I load a picture into the sheet image control from the form. I set some of the properties of the control, the picture is fine....

    If I close the form, with an unload statement, or press the windows X button to close the form without doing anything after it has intialized the form, the picture control reverts back to it's original picture.

    When a form is unloaded, does something take place to make this happen?

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

    Re: image control (Excel 2003)

    I can't reproduce the problem in a quick test. The properties I modified persisted after closing the userform. Could you attach a small demo workbook? Strip out everything not needed for this problem.

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

    Re: image control (Excel 2003)

    Hans,

    I worked on it some more and discovered that when the form was loaded it had a case statement loading the picture, so when I closed the form it reverted back to what I told it to revert back to using a case statement.

    Thanks
    Darryl.

Posting Permissions

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