Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro launched when condition is true
Hi
I'm wonder if the following sceario is possible: I have got macro and I want this macro be launched whenever the cell(1,1) = 5 (or when this cell is changed) Thank you for your proposals. Best Regards D.Tomon |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro launched when condition is true
If it will hold a formula, then you could use the Calculate event to check -
but you would have to use a static variable to record the old variable to run only when it has changed. If it will hold a constant value which will be edited by the user, then you could use the Change event See Chip Pearson's page on events for an overview http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "Dariusz Tomon" wrote: Hi I'm wonder if the following sceario is possible: I have got macro and I want this macro be launched whenever the cell(1,1) = 5 (or when this cell is changed) Thank you for your proposals. Best Regards D.Tomon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find first row where condition is true? | Excel Discussion (Misc queries) | |||
result if a condition is NOT true? | Excel Worksheet Functions | |||
TRUE condition??? | Excel Discussion (Misc queries) | |||
Save If Condition is true | Excel Programming | |||
How Do I Hide A Row (if a condition is true) using a Macro ? | Excel Worksheet Functions |