Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do get a macro to autorun when i change a cell in the spreadsheet?
Let say Cell "A1" has only 2 values that is Purchase or Sales. Now when i change this cell to either value, i want it to run a macro e.g. When i change Cell to "Purchase" i want to autorun Macro A And When i change Cell to "Sales" i want to autorun Macro B How do i do this? And it is for a particular worksheet only. Thanks in advance. -- Infinity ------------------------------------------------------------------------ Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725 View this thread: http://www.excelforum.com/showthread...hreadid=526617 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoRun Macro | Excel Worksheet Functions | |||
Autorun a macro on change of cell value (having formula) | Excel Worksheet Functions | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming | |||
autorun a macro | Excel Programming | |||
Autorun macro on opening spreadsheet | Excel Programming |