| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a Macro run after every cell adjustment
Hi,
I'm trying to run a macro that constantly monitors a file. so that every time a cell value is added or changed the macro checks for certain errors. Is this possible? Many Thanks Dwight |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to make a Macro run after every cell adjustment
Depending on how the cell is changed (typing or calculation), you could tie into
a worksheet event. Chip Pearson has lots of info: http://cpearson.com/excel/events.htm Dewey wrote: Hi, I'm trying to run a macro that constantly monitors a file. so that every time a cell value is added or changed the macro checks for certain errors. Is this possible? Many Thanks Dwight -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to make a Macro run after every cell adjustment
Thanks for that Dave.
Dewey Dave Peterson wrote: Depending on how the cell is changed (typing or calculation), you could tie into a worksheet event. Chip Pearson has lots of info: http://cpearson.com/excel/events.htm Dewey wrote: Hi, I'm trying to run a macro that constantly monitors a file. so that every time a cell value is added or changed the macro checks for certain errors. Is this possible? Many Thanks Dwight -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro adjustment | Excel Discussion (Misc queries) | |||
| Search macro adjustment | Excel Programming | |||
| Event Macro adjustment needed - need to change font color also | Excel Worksheet Functions | |||
| macro adjustment help | Excel Programming | |||
| Slight adjustment needed for Macro | Excel Programming | |||
Linear Mode
