brockvilleal
New Member
- Joined
- Aug 19, 2004
- Messages
- 47
I am new at this but everywhere I look, VBA help, various forums, I cannot find an answer to my question.
I have created a userform with 7 option buttons. When the user clicks on one of the option buttons, I want that particular choice to take the user to a specific worksheet. For instance one of the options is "Help". If that option is selected, then I want the help worksheet to appear. The help worksheet is one of many worksheets.
I think the VBA should be something like this:
Private Sub OptionButton3_Click()
Open "Sheet2!A1"
End Sub
where the "Open ..." is obviously wrong but I do not know what the code is.
Any help would be appreciated.
Al
I have created a userform with 7 option buttons. When the user clicks on one of the option buttons, I want that particular choice to take the user to a specific worksheet. For instance one of the options is "Help". If that option is selected, then I want the help worksheet to appear. The help worksheet is one of many worksheets.
I think the VBA should be something like this:
Private Sub OptionButton3_Click()
Open "Sheet2!A1"
End Sub
where the "Open ..." is obviously wrong but I do not know what the code is.
Any help would be appreciated.
Al