| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run on cell change macro question
I am running a macro that is triggered by a cell entry (or change). The
macro itself rounds the value entered into the cell to the next 0.5 value and replaces it. This action of replacing the value triggers the macro to repeat. How do I stop it? (counter won't work because it resets to empty when macro is re-run) OR Is there a way to set the macro to run only once, then quit? OR Is there another way to achieve the desired result? I also tried entering the formula directly into the entry cells on the page, but I get a circular reference. Thanks, Randy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run on cell change macro question
Hi Randy,
Try: Application.EnableEvents = False 'Your rounding code Application.EnableEvents = True --- Regards, Norman "RAP" wrote in message ... I am running a macro that is triggered by a cell entry (or change). The macro itself rounds the value entered into the cell to the next 0.5 value and replaces it. This action of replacing the value triggers the macro to repeat. How do I stop it? (counter won't work because it resets to empty when macro is re-run) OR Is there a way to set the macro to run only once, then quit? OR Is there another way to achieve the desired result? I also tried entering the formula directly into the entry cells on the page, but I get a circular reference. Thanks, Randy |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run on cell change macro question
Thank you, Norman. I was THAT " " CLOSE !! I appreciate it.
Randy "Norman Jones" wrote: Hi Randy, Try: Application.EnableEvents = False 'Your rounding code Application.EnableEvents = True --- Regards, Norman "RAP" wrote in message ... I am running a macro that is triggered by a cell entry (or change). The macro itself rounds the value entered into the cell to the next 0.5 value and replaces it. This action of replacing the value triggers the macro to repeat. How do I stop it? (counter won't work because it resets to empty when macro is re-run) OR Is there a way to set the macro to run only once, then quit? OR Is there another way to achieve the desired result? I also tried entering the formula directly into the entry cells on the page, but I get a circular reference. Thanks, Randy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro that will change the font of a cell if i change a value | Excel Discussion (Misc queries) | |||
| Worksheet change Macro Question | Excel Discussion (Misc queries) | |||
| Really basic question! Cell colours change when emailed. | Excel Discussion (Misc queries) | |||
| Easy question - If ...then Change cell value | Excel Programming | |||
| Question: Cell formula or macro to write result of one cell to another cell | Excel Programming | |||
Linear Mode
