Microsoft Office Tutorials and References
In Depth Information
Using the MultiPage Control in a UserForm
Double-clicking an item in the ListBox has the same result as clicking the OK button. The
ListBox1_DblClick procedure, which follows, simply calls the OKButton_Click procedure.
Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Call OKButton_Click
End Sub
This example is available on the companion CD-ROM. The file is named listbox
activate sheet.xlsm .
Using the MultiPage Control in a UserForm
The MultiPage control is useful for UserForms that must display many controls. The
MultiPage control lets you group the choices and place each group on a separate tab.
Figure 14-18 shows an example of a UserForm that contains a MultiPage control. In this case,
the control has three pages, each with its own tab.
This example is available on the companion CD-ROM. The file is named multipage
control demo.xlsm .
Figure 14-18: MultiPage groups your controls on pages, making them accessible from a tab.
 
Search JabSto ::




Custom Search