ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change a caption for multipage (https://www.excelbanter.com/excel-programming/433329-change-caption-multipage.html)

Oakleaf tech[_2_]

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



Jacob Skaria

Change a caption for multipage
 
Refer the index which starts from 0. For the first page

MultiPage1.Pages(0).Caption = DocumentCbx.Text

If this post helps click Yes
---------------
Jacob Skaria


"Oakleaf tech" wrote:

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



Oakleaf tech[_2_]

Change a caption for multipage
 
That did the job!

Thx a million!

"Jacob Skaria" wrote:

Refer the index which starts from 0. For the first page

MultiPage1.Pages(0).Caption = DocumentCbx.Text

If this post helps click Yes
---------------
Jacob Skaria


"Oakleaf tech" wrote:

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




All times are GMT +1. The time now is 09:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com