MultiPage tab?

C

capt

I have a userform which I have inserted one multipage with three pages. Is
there a way to link the tab on a multipage to one of the lable box?
 
C

capt

Further to my last.
This is in oder to rename the tab by inserting the text in a lable box.

Thanks
 
D

Dave Peterson

How about using a textbox that you can change:

Option Explicit
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
With Me.MultiPage1
.Pages(.Pages.Count - 1).Caption = Me.TextBox1.Value
End With
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multipage tab question 3
MultiPage 2
MultiPage tomfoolery 1
Tabs query 3
User form 1
Multipage label caption 2
activate a page of a Multipage in Userform 1
View sheets (pages) horizontally 1

Top