Switch images in VBA

A

AnQi

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!
 
T

Tom Ogilvy

Range("B9").Select
ActiveSheet.Pictures.Insert("C:\WINDOWS\HLPBELL.GIF")

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.
 
Top