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/