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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation of cell value with worksheet change event
On May 30, 5:03*pm, Raj wrote:
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 Use the selection change event instead - this returns as a target the cell that has just been left |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation of cell value with worksheet change event
Private Sub Worksheet_Change(ByVal Target As Range)
Set b1 = Range("B1") If Intersect(Target, b1) Is Nothing Then Exit Sub Application.EnableEvents = False ' ' update A1 ' Application.EnableEvents = True MsgBox ("B1 changed") End Sub Should work if B1 is refreshed with a value followed by ENTER, or by a mouseclick, or by an ARROW movement. -- Gary''s Student - gsnu200789 "Raj" wrote: 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 |
Reply |
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 |