| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Picture in a UserForm | Excel Discussion (Misc queries) | |||
| How to get a picture on a userform? | Excel Programming | |||
| How to get a picture on a userform? | Excel Programming | |||
| Picture show in image1 | Excel Programming | |||
| displaying picture in a userform | Excel Programming | |||
![Abdul[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
