Posted to microsoft.public.excel.programming

Abdul[_2_] Abdul[_2_] is offline

external usenet poster

Posts: 137

Remove Picture from Image1 on a Userform

I have the following to show a chart in a userform:

SetSourceData Source:=Range("MyRange")
......

Fname = ThisWorkbook.Path & Application.PathSeparator & "Temp.gif"
CurrentChart.Export Filename:=Fname, FilterName:="GIF"
........

Image1.Picture = LoadPicture(Fname)

If "MyRange" is error or Null the how i can say the to remove the
current picture of image1 and just show empty image1

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Picture in a UserForm	Howard31	Excel Discussion (Misc queries)	1	December 20th 08 03:27 PM
How to get a picture on a userform?	Alex	Excel Programming	0	March 27th 06 12:07 AM
How to get a picture on a userform?	sebastienm	Excel Programming	0	March 26th 06 11:58 PM
Picture show in image1	Ivica Lopar	Excel Programming	6	November 13th 05 09:57 PM
displaying picture in a userform	Todd Huttenstine[_3_]	Excel Programming	1	January 28th 04 02:42 AM

All times are GMT +1. The time now is 05:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us