+ Reply to Thread
Results 1 to 7 of 7

Userform show (default tab)

  1. #1
    Registered User
    Join Date
    07-30-2009
    Location
    Vancouver, British Columbia
    MS-Off Ver
    Excel 2010
    Posts
    46

    Talking Userform show (default tab)

    Hi,

    I have a userform with multiple tabs. I have buttons on the excel sheet that correspond with the tabs. How do I get the buttons to open up their respective tabs in the userform?

    For example: Button 1 opens Userform-Tab1; Button 2 opens Userform-Tab2; Button 3 opens Userform-Tab3; etc.

    Right now they all open the userform, but open the first tab.

    Any ideas

    Cheers,
    Last edited by ilovelagar; 09-24-2009 at 03:32 PM. Reason: Solved

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Userform show (default tab)

    Are you talking about a multiPage control?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    07-30-2009
    Location
    Vancouver, British Columbia
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Userform show (default tab)

    Quote Originally Posted by royUK View Post
    Are you talking about a multiPage control?
    I'm not sure if that's the correct term ...

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Userform show (default tab)

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!

  5. #5
    Registered User
    Join Date
    07-30-2009
    Location
    Vancouver, British Columbia
    MS-Off Ver
    Excel 2010
    Posts
    46

    Question Re: Userform show (default tab)

    Here's a dummy sheet

    Just to summarize the sheet, there's two buttons: Day One (red button) and Day Two (blue button). When you click either button the userform pops up. In the userform there are two tabs "Day One" and "Day Two". However both the red and blue button open up the userform with the "Day One" tab as the default. I would like the red button to open up the userform on the Day One tab, and the blue button to open up the userform on the Day Two tab.

    Cheers,
    Attached Files Attached Files

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Userform show (default tab)

    The tab numbers start at zero, so
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    07-30-2009
    Location
    Vancouver, British Columbia
    MS-Off Ver
    Excel 2010
    Posts
    46

    Talking Re: Userform show (default tab)

    Perfect, that's what I needed!

    Cheers!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1