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