Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Useform Properties

Status
Not open for further replies.

LGMan

MIS
Aug 27, 2003
233
GB
Hi, I am using a multipage userform and am trying to get an optionbutton control on page 1 to open page 3.
trouble is I can't suss out the command for this.

Any help greatfully received.
 
Change Value of multipage control to 2 (it's 0-based index, i.e. 0 for page 1, 1 for page 2 etc.).

combo
 
So....

If you have OptionButton1 on Page1 (index = 0) of the MultiPage:
Code:
Sub OptionButton1_Click()
   MultiPage1.Value = 1
End Sub
clicking the OptionButton will make Page2 (index = 1) of the MultiPage get the focus.

It does seem a little odd to use an OptionButton for this.

Gerry
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top