| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switch images in VBA
Hi all,
Anybody knows how to display an image in a cell in Excel and swtich it with other images given a integer parameter? Any suggestion is much appreciated. Thanks! --- Message posted from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Switch images in VBA
Range("B9").Select
ActiveSheet.Pictures.Insert("C:\WINDOWS\HLPBELL.GI F") will insert a picture. You can insert two pictures, then make one hidden. Alternate back and forth using the calculate event or change event depending on how the integer is changed. -- Regards, Tom Ogilvy AnQi wrote in message ... Hi all, Anybody knows how to display an image in a cell in Excel and swtich it with other images given a integer parameter? Any suggestion is much appreciated. Thanks! --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Images and Links | Excel Discussion (Misc queries) | |||
| Linking images | Excel Worksheet Functions | |||
| Chart.Export images are shrinking as I export more images | Charts and Charting in Excel | |||
| Images do not load | Excel Discussion (Misc queries) | |||
| Exporting images | Excel Programming | |||
Hybrid Mode
