accessing drawn objects

[Sandra]

Is there any way to have a cell take a drawn object from
another cell? For example, when I say +b3 in cell a3,
and b3 has a drawn object, I get 0 in a3. I want to
print one picture in sheet B, if the user enters "1" in
sheet A. If he enters "2", I want to print a different
picture.

 

[Frank Kabel]

Hi Sandra
you'll need VBA for this (Excel's formulas can only return values but
not objects). See
http://www.mcgimpsey.com/excel/lookuppics.html
for an example