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