Image Control Question
On Mon, 22 Sep 2008 10:45:55 -0400, "Rick Rothstein"
wrote:
Put this statement in the (General)(Declarations) section of the UserForm's
code window...
Dim OriginalPicture As StdPicture
Then put this in the UserForm's Initialize event...
Set OriginalPicture = Image1.Picture
Now, whenever and wherever you want to restore the original picture for the
Image1 control, just execute this statement...
Set Image1.Picture = OriginalPicture
Thanks Guys, I've spent quite a long time trying to achieve this and
have concluded it's just not worth it ! The 'Set" command seems to
cause Excel to crash with that 'Sorry for the inconvieniance' thing.
Then it spends hours recovering....
The simplist fix is not have any default image and create the required
one each time. Problem gone.
My original theory seemed Ok: if the image exists, use it
otherwise use the default - but too much hassle !
Thanks for the suggestions and help though.
Cheers - Kirk
|