How do I specify "tab To" cells in an excel spreadsheet?
I want to automatically tab to certain cells to make data entry easier
How do I specify "tab To" cells in an excel spreadsheet?
I want to automatically tab to certain cells to make data entry easier
With a very simple piece of code???
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
I was hoping to tab to the next input cell by hitting tab button, rather hit a button that tells which cell to go to
Hi
If I use E10, F13 and I13 as input cells, how about this in Sheet 1 of Glenn's version:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim KeyCells As Range
' The variable KeyCells contains the cells that will
' cause an alert when they are changed.
Set KeyCells = Range("E10:I13")
If Not Application.Intersect(KeyCells, Range(Target.Address)) _
Is Nothing Then
' Display a message when one of the designated cells has been
' changed.
' Place your code here.
' MsgBox "Cell " & Target.Address & " has changed."
Select Case Target.Address
Case "$E$10"
Range("$F$13").Activate
Case "$F$13"
Range("$I$13").Activate
Case "$I$13"
Range("$E$10").Activate
End Select
End If
End Sub
Based on https://support.microsoft.com/en-us/kb/213612
Regards
Alan Clubb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks