Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Change Events
I am monitoring a column on a worksheet for changes - using the change
event. I check that the column is the correct one and use the value of the cell to decide on the action to take. Code as follows Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 9 And Target.Value 0 Then ' take some action End If End Sub All works well until I select a Range of cells, then the Target.Value throws an error. My questions are 1. How can I test if the user has chosen more than one cell ? 2. How can I iterate through a multi-cell selection and act on each value in turn? Many thanks -- Cheers Nigel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine 2 worksheet change events | Excel Discussion (Misc queries) | |||
Handling Worksheet Events of a Worksheet Created During Runtime. | Excel Programming | |||
Worksheet Change Events | Excel Programming | |||
Understanding change events | Excel Programming | |||
worksheet change event error events disabled | Excel Programming |