Remove Picture from Image1 on a Userform

A

Abdul

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Image on userform from picture in a worksheet 2
paste 2 charts on the same image on a userform 2
Chart Picture Size in UserForm/Picture Control. 8
Picture in spreadsheet to picture in userform? 4
Image control 2
Better quality with GIF export method, are there any switches ? 4
Delete temp file 2
Running macro automatic after opening Userform 4

Top