View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Oakleaf tech[_2_] Oakleaf tech[_2_] is offline
external usenet poster
 
Posts: 3
Default Change a caption for multipage

I want to change the caption on a multiforms pages depending on the selection
made in a combo box on the userform.

The combobox is called DocumentCbx
The userform = InvoiceUserForm
The multipage = MultiPage1
the pagename = DocuDet
And the caption will vary depending the value of DocumentCbx

Here is the coding as far as I can manage it.

I did put in ???? where i am not sure what to do further

private Sub DocumentCbx_Change()
Dim DocumentDetails As String

If InvoiceUserform.DocumentCbx.Value = "tax invoice" Then
InvoiceUserform.MultiPage1.????????
Else

End If

End Sub

Thx