| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect the cell's value change?
Hello,
In my vbasic application I am using Excel automation. How to detect (which event to use) when user changes the value of the selected cell? Thanks, Jack |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to detect the cell's value change?
Hi Jack
The Worksheet_Change event is what you need. It returns a Target range, which is the cell beeing changed. Private Sub Worksheet_Change(ByVal Target As Range) msg = MsgBox("Cell " & Target.Address & " has been changed") End Sub Regards, Per "Jack" <replyto@it skrev i meddelelsen ... Hello, In my vbasic application I am using Excel automation. How to detect (which event to use) when user changes the value of the selected cell? Thanks, Jack |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CHANGE ONE CELL'S VALUE AND GET THE SAME RETURN - SOME HELP PLEASE | Excel Discussion (Misc queries) | |||
| for the change that change event cant detect | Excel Programming | |||
| Change value based on another cell's value | Excel Discussion (Misc queries) | |||
| How to change an other cell's value? | Excel Discussion (Misc queries) | |||
| Change a cell's value using a button | Excel Discussion (Misc queries) | |||
Linear Mode
