Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |