Use password text box and command button on userform

Greetings everyone!

I have a problem that I hope you can help me with.

I have a userform named Bldg_Search and on the userform there is a multipage strip which is named MultiPage1 which takes up half of the userform with four tabs labeled Page1 thru Page 4. My goal is to have a textbox named passfield and a command button labeled passcommand and its purpose would be to make visible Page 4 located on the multistrip. any code would be very much appreciated. I found some examples on the various sites, but none that did what I described above.

Thanks again,
David

.
Here is a sample project using a three tab Multipage control on the userform.
The third tab is normally hidden until the correct password is entered.

The password for this project is: pw

When using a multipage control remember that the first tab is referred to in VBA code as "0". The second tab is referred to as "1", etc. etc.

Please Login or Register  to view this content.

I’ll give that a try. Thanks a lot! I will report back later.

.
If you only want the tab disabled and not hidden, use this code :

Please Login or Register  to view this content.

Your code works perfectly. However, when the userform is unloaded and then shown again, the contents of the text box is still there? Can you give me a code insert that will clear the textbox when the userform unloads?

thanks,
david

Thanks for your input and example. I will try out your example also just for practice.

david

.

Please Login or Register  to view this content.

perfect! thanks

.
You are welcome.