Thread: MultiPage tab?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default MultiPage tab?

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