ClipArt to macro

G

Guest

First let me say I appreciate everyone's help. Me being a novice, you guys
are a real help.
I would like to make a macro that would let me insert a pic (clipart) onto a
worksheet. This clipart would insert on a worksheet if certain values are
true.
THANKS
Glenn
 
T

Tom Ogilvy

turn on the macro recorder and do

Insert=>Picture, then from file etc.

Position it where you want.

Turn off the macro recorder. Modify the code to do what you want.

To tie it to some condition, what generates the condition - someone editing
a cell, a calculation?

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clipart in Marco 1
INSERT PICTURE IN MACRO 1
Simple Macro 1
How to open a linked graphic? 4
Using a macro to insert a clipart object into a word template 4
MACRO 2
No more clipart or Symbols?! 3
clipart problem 1

Top