+ Reply to Thread
Results 1 to 4 of 4

Specify "Tab To" Cells

  1. #1
    Registered User
    Join Date
    06-01-2015
    Location
    Maine
    MS-Off Ver
    2013
    Posts
    2

    Specify "Tab To" Cells

    How do I specify "tab To" cells in an excel spreadsheet?
    I want to automatically tab to certain cells to make data entry easier

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,139

    Re: Specify "Tab To" Cells

    With a very simple piece of code???
    Attached Files Attached Files
    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

  3. #3
    Registered User
    Join Date
    06-01-2015
    Location
    Maine
    MS-Off Ver
    2013
    Posts
    2

    Re: Specify "Tab To" Cells

    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

  4. #4
    Registered User
    Join Date
    04-11-2016
    Location
    Daventry, England
    MS-Off Ver
    2016
    Posts
    24

    Re: Specify "Tab To" Cells

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  3. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  4. [SOLVED] Formula Needed to fill multiple cells with "No" when the word "No" is entered into a cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2013, 05:36 PM
  5. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  6. [SOLVED] Data validation: allow entry into a cell if other three cells have "X", "Y" and "Z"?
    By RogerRangeRover in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2013, 04:49 AM
  7. Problem using "Cells" in "Range" "400" error
    By johnnywinter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2009, 05:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1