You would need VBA unless you want to do it very manually.
"Insert Selected Picture Into Comment"
http://www.contextures.com/xlcomments03.html#Picture

If you are used to writing your own HTML code, you could create HTML
code using worksheet formulas and insert that code into an HTML page.

If you show a picture in Excel then that picture has to reside in your workbook.

An alternative that might work for you would be use of the HYPERLINK
Worksheet Formula which would alloc you to click on the link and see the
picture.

A1: 001 format as 000
B1: Beautify Sunset
C1: =HYPERLINK("c:\camera-canon20d\img_" & TEXT(A1,"0000") & ".jpg","[pic]")
A2: 002 format as 000
B2: Another sunset from same location
C2: =HYPERLINK("c:\camera-canon20d\img_" & TEXT(A2,"0000") & ".jpg","[pic]")

If you want to create a slide show, you could use a free applicatioin like
IrfanView (irfanview.com) -- I have some directions for my own use on
http://www.mvps.org/dmcritchie/excel/irfanview.txt

Why you should be using newsgroups directly instead of web forums
http://www.mvps.org/dmcritchie/excel...htm#postdirect
http://www.mvps.org/dmcritchie/excel/forums.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"starguy" wrote in message
...

I have snaps in a folder and all snaps are named by serial No. as
1,2,3...and so on. I want that when I put 1 in a cell, snap named as 1
should appear in right cell (or might be required at left).

could that be done without vba.