ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Remove Picture from Image1 on a Userform (https://www.excelbanter.com/excel-programming/374209-remove-picture-image1-userform.html)

Abdul[_2_]

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


NickHK[_3_]

Remove Picture from Image1 on a Userform
 
Abdul,
Image1.Picture = LoadPicture("")

NickHK

"Abdul"
groups.com...
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





All times are GMT +1. The time now is 10:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com