+ Reply to Thread
Results 1 to 6 of 6

Userform Multipage, remember last tab open tab on close

  1. #1
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Userform Multipage, remember last tab open tab on close

    Is there a way to remember the last open tab of a Multipage control in a userform, when it closes?
    Such that when the macro is called up again, it shows the last open tab.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Userform Multipage, remember last tab open tab on close

    One thing I can think of is to create a worksheet to track the MultiPage control setting. On the userform terminate event, you can log the last used tab. On the initialize event, you assign the value from the tracker sheet. For example

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Re: Userform Multipage, remember last tab open tab on close

    @JieJenn, thanks for directing me this way.
    Was there any way to store the variable within the code and not output to a cell?

  4. #4
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Userform Multipage, remember last tab open tab on close

    Perhaps, if you want to avoid using the helper worksheet, use a text label to store the multipage control value, and make the text label invisible.

  5. #5
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Re: Userform Multipage, remember last tab open tab on close

    OK thank-you, I will give this a try.

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Userform Multipage, remember last tab open tab on close

    If you are actually closing, not hiding, the userform then you would need to store the multipage value somewhere.

    That could be on a worksheet, as has been suggested, but you could also consider a small text file, a custom property etc.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 03-23-2018, 03:52 PM
  2. Userform Open Close Help
    By dgibney in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-16-2017, 05:54 PM
  3. Close one userform and open next one
    By lauro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2016, 04:10 AM
  4. [SOLVED] Open UserForm on specific Multipage
    By PDBartlett in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2014, 06:07 AM
  5. Open UserForm that contains a MultiPage and Scroll Bar
    By Gal403 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2014, 02:27 AM
  6. [SOLVED] Userform multipage tab to open Sheet2 of workbook
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-16-2013, 08:02 AM
  7. How to Open 2nd workbook from userform, then close 2nd Userform
    By bigfoot007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2012, 02:03 PM

Tags for this Thread

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