Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clipart in Marco
i do not understand this responce???
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 -- Regards, Tom Ogilvy "Glenn" wrote in message ... 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 Expand AllCollapse All |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clipart in Marco
Glenn,
Excel has a macro recorder. In the Tools menu choose Macros then Record New Macro. Tom was suggesting that you turn on the recorder and then insert the picture using Excel commands and then turn off the recorder. You can then go into the Visual Basic Editor and view the macro that was recorded. This is a great tool for learning how to code. For more info Google "macro recorder Excel." One link I found was http://www.redtechpress.com/macros.pdf which looks pretty helpful. Second, he was asking what would trigger inserting the picture. You said "if certain values are true." This means that you will have to use events, such as WorkSheetChange, which occurs when a cell in a worksheet changes value. Look at the link Tom gave you for more info. hth, Doug "Glenn" wrote in message ... i do not understand this responce??? 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 -- Regards, Tom Ogilvy "Glenn" wrote in message ... 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 Expand AllCollapse All |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
washout of clipart in Excel 2007 / send back clipart behind text | Excel Discussion (Misc queries) | |||
How do I float a clipart object | Excel Discussion (Misc queries) | |||
how do i import clipart into powerpoint | New Users to Excel | |||
ClipArt to macro | Excel Programming | |||
adding clipart | Excel Discussion (Misc queries) |