Excel 2007
Spread sheet with 315 rows. Need to select from data validation dropdown lists in column C and column D. It take the user 3 clicks to move focus to the cell, initiate the data validation dropdown, and make a selection.Is there some way (Excel or VBA) to automatically put focus on the next cell, eliminating one of the three needed clicks? Seems trivial but having to do 3 clicks for 630 cells gets tedious very quickly and if there is a way to cut that down it would make the users VERY happy.
Thanks,
Fergie
Right click the sheet tab for the sheet with the drop downs and paste this code into the pane that opens. Whenever a change is made to Column C, the cell in Column D, same row will be selected.
As written, it works for the entire column. If you need it to work for only a specific range, see the alternate code for an example on how to limit it to just a specific range.
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 3 Then Target.Offset(0, 1).Select End SubAlternate, for a specific range:
Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("C1:C300")) Is Nothing _ Then Target.Offset(0, 1).Select End SubPosting Tip: Before posting Data or VBA Code, read this How-To.
I messed with that for hours and misunderstood the concept... I'm shocked that it was that simple. I can add another IF to push the pointer to the next line and back to column C.... Super! Thank you very much.
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |