View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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