LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 150
Default Worksheet Change event - not running when down arrow is pressed

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
worksheet change event running slow Justin Larson[_2_] Excel Programming 3 July 25th 09 04:54 PM
Worksheet Change event not running a macro Brettjg Excel Programming 10 April 6th 09 03:42 PM
combobox change event is running when enable events is false tysop Excel Programming 3 January 24th 06 02:16 PM
Workbook_BeforeClose change event not running correctly Peter Rooney Excel Programming 4 August 5th 05 04:26 PM


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"