excel Tabstrip reposition controls based on user input

Posted on 2012-08-29
Medium Priority
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

tdlewis earned 1500 total points
ID: 38348695
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

ID: 38349434
thank you

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
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…

850 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