harpscardiff,
You set the multiplages value to 1 less than the page you want to show - the pages are 0 based, not
1 based, so something like
frmsysenq1.MultiPage1.Value = ValueFromRadioButtons - 1
will show the correct page
HTH,
Bernie
MS Excel MVP
"harpscardiff" wrote in message
news:harpscardiff.24av4y_1141735501.3499@excelforu m-nospam.com...
Hi,
I have two forms, 1) asks the user to select either 1, 2, 3, 4 or 5
(radio buttons).
2) the second form is questions based on the system they select on the
1st form, in a form of a multipage.
Based on the system they selected, on the first form, I want the form
to select that tab. So if the user selected system 1, the second form
will popup, on the tab system 1.
I've tried the following:
Code:
--------------------
Private Sub cmdOK6_Click()
If optAS400 = True Then
ActiveWorkbook.Sheets("AS400").Activate
frmsysenq.show ' not sure how to select a tab
End If
End Sub
--------------------
Cheers.
--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=519689