How to use Graphics/Objects in a formula

[Guest]

I want to use a formula such that "IF A=1 then copy a specific graphic/object on worksheet2 and paste it at a particular place in worksheet1"

Any body has a clue?? Thanks...

 

[Tom Ogilvy]

Depends on how A becomes 1.

If A refers to a cell and it changes value because of a formula, then use
the calculate event.

If A refers to a cell and it changes because someone edited it, then use the
change event.

See Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

You can get code for inserting a graphic on the worksheet by turning on the
macro recorder and doing

Insert=>Picture=>From file

--
Regards,
Tom Ogilvy

I want to use a formula such that "IF A=1 then copy a specific

graphic/object on worksheet2 and paste it at a particular place in
worksheet1".