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.
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.
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.
@JieJenn, thanks for directing me this way.
Was there any way to store the variable within the code and not output to a cell?
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.
OK thank-you, I will give this a try.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks