Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation of cell value with worksheet change event
Hi,
I have an integer in cell a1. When an integer is input in cell b1, I need the value in cell a1 multiplied by the value in cell b1 and the result placed in cell a1. To achieve this I am using the Worksheet_change event with target range as b1. The program works ok when the user inputs the value in cell b1 and then presses the Enter key. However, if the user clicks outside cell b1 after inputting the value in cell b1, then the value in cell a1 does not change. How do I ensure that the calculation takes place when the user exits b1? How can I achieve this through a worksheet event?. Is there an event that fires when the cell is exited? Is there any other way to do this? Thanks in advance for the help. Regards, Raj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What cell caused the worksheet change event | Excel Programming | |||
change event on specific cell rather than worksheet | Excel Discussion (Misc queries) | |||
Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming |