Worksheet Change event - not running when down arrow is pressed
The worksheet_change event will fire if you make a change. Using the arrow key
to travel down the column isn't making changes to the worksheet.
If you're trying to fix something that's already been entered, maybe using a
dedicated macro (run it once to fix the existing data) would be better.
ps. instead of using selection.row, I'd use target.row.
But since you're using the 3rd column, isn't:
me.cells(target.row,3).value the same as Target.value
(assuming a single cell was changed)
Raj wrote:
Hi,
I am using the worksheet change event to run code when the value in a
cell in Column C is changed..
If Not Application.Intersect(Target, Me.Range("c2:c65536")) Is Nothing
Then
If Me.Cells(Selection.Row, 3).Value < "" Then
Do this.....
End If
End If
The code runs if Enter key is pressed but will not run if the down
arrow key is pressed.
What can I do to make the code run when the arrow key is pressed?
Thanks in advance for the help.
--
Dave Peterson
|