ExcelBanter - MultiPage tab?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - MultiPage tab? (https://www.excelbanter.com/excel-discussion-misc-queries/174688-multipage-tab.html)

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?
--
capt

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

Thanks
--
capt

"capt" wrote:

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?
--
capt

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

capt wrote:

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

Thanks
--
capt

"capt" wrote:

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?
--
capt

--

Dave Peterson