Excel Tab Order: I attempted this solution but it did not work for me

Posted on 2011-04-26
Last Modified: 2012-05-11
I downloaded the spreadsheet and copied the code. Im stepping through the code and it looks as though it is firing properly but it is not tabbing in the order specified.
Question by:sullisnyc44
    LVL 81

    Expert Comment

    by:zorvek (Kevin Jones)
    How do you understand the tabbing to work? Can you post the workbook?


    Author Comment

    Sorry - I was just about to delete the question. I think I have it working now. My apologies.

    I do have a question though - instead of explicit cell references, can I use named ranges? Also from what I can gather looking at the code, this will work on merged cells?
    LVL 81

    Accepted Solution

    It will work on merged cells. Use the first cell in the merged area as the tab destination. Note this line in the code handles merged ranges:

       If Cell.Address = Cell.MergeArea(1, 1).Address Then

    Yes, you can used named ranges.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now