Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to start a Macro
I have a macro that adds a graphic image to a cell. I want the condition of
another cell to be the trigger to run the macro. If the trigger cell goes high (is not blank) I want the macro to run one time. Can I do this with an if statment? if not please suggest. -- Rick |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to start a Macro
Go to Tools-Macro-Macros
select your macro, and click Edit. Where it says Sub Macro() Replace with: Private Sub Worksheet_Change(ByVal TargetCell As Range) Then, skip past the comments (the rows starting with ') and enter: If (Range("A1") = 10) Then Leave your steps that insert the picture here then enter: End If This assumes that A1 is your determining cell, and that a value of 10 or greater is large enough to trigger the macro. "Rick_T" wrote: I have a macro that adds a graphic image to a cell. I want the condition of another cell to be the trigger to run the macro. If the trigger cell goes high (is not blank) I want the macro to run one time. Can I do this with an if statment? if not please suggest. -- Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you start a Macro? | New Users to Excel | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
link to combobox | Excel Discussion (Misc queries) | |||
Macro to Start an Application | Excel Discussion (Misc queries) | |||
Start Macro Daily task | Excel Discussion (Misc queries) |