excel Tabstrip reposition controls based on user input

Posted on 2012-08-29
Last Modified: 2012-08-30
I would like to program an excel user form tabstrip to reposition visible controls based on user input in a textbox.  How do I cause all visible controls to reposition so those invisible controls do not appear as missing?

Instead of this                                     I need               something like this
        |                                                                                      |
        V                                                                                      V ______________________________________                        ________________________________________
|  *_______                   *________        |                      |   *_________                                        |
|                                                        |                      |   *_________                                        |
|  *_______                                         |                      |   *_________                                        |
|                                                        |                      |   *_________                                        |
|                                   *________       |                      |                                                          |
 ______________________________________                        _________________________________________
Question by:Tony_Rhoades
    LVL 10

    Accepted Solution

    Just figure out which controls need to move and to which location on the form and then within the code for the form, you can do something like this:
    Me.nameOfControl.Left = 20
    Me.nameOfControl.Top = 75

    Open in new window


    Author Closing Comment

    thank you

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    732 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

    23 Experts available now in Live!

    Get 1:1 Help Now