Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Tab function

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    We have a very simple Excel question/problem. We are developing a form here at work. What we would like to do is have the 'user' hit the tab key and it go to the next cell that needs to be completed.

    Can this be done without running any Macros? If not what would the VBA code be?

    Thanks for any help/suggestions,
    BACHBELL

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Unlock the cells to which you want to tab. Protect the worksheet.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry, got there too late!

    Hi,

    You can select the cells you want to tab between and format them to be unlocked, then protect the sheet.

    Now when you press tab you'll only go between those cells

    Regards

    [ This Message was edited by: Audiojoe on 2002-02-26 07:18 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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