Command button help

Posted on 2012-08-19
Last Modified: 2012-08-20
Please can you help with the two command buttons in the attached.

Depend on which is pressed, I'd like the code to search along the columns and find the next month.

Line 2 the current month is in E2 "01/03/2012" if I click "Plus" or command button two, I would like the code to recognise and then jump to selection to AA2 "01/03/2012" and so on until the end of the range.

I would like command button 1 to do the same but in reverse.
Question by:Kiwi-123
    LVL 8

    Accepted Solution

    Is this how you wanted it? This scrolls to the right or left of the heading no matter which row you're at.

    Author Closing Comment

    Many thanks for your help.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    729 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

    21 Experts available now in Live!

    Get 1:1 Help Now