Switch images in VBA

  • Thread starter Thread starter AnQi
  • Start date Start date
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!
 
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.
 
Back
Top