I posted ealier a question regarding option buttons but I was unsucessful in getting it going. Please could you look and offer me any solutions. The code that I am using is:
Sub Start_Click()
If optionbutton1 = True Then
Worksheets("Labels").Select
ElseIf optionbutton2 = True Then
Worksheets("Products").Select
End If
End Sub
I have two option buttons on a dialog box, and a button named start, with code in the "onclick event".
1 Continue with existing labels (button1)
2 Create new labels (button2)
What I want to do is if the user presses the top button then presses Start, the code needs to open up the labels worksheet, or if the user chooses the second option and clicks on the start button it opens up the product worksheet. Please help
Thanks in advance - not sure what I am doing wrong!!
Sub Start_Click()
If optionbutton1 = True Then
Worksheets("Labels").Select
ElseIf optionbutton2 = True Then
Worksheets("Products").Select
End If
End Sub
I have two option buttons on a dialog box, and a button named start, with code in the "onclick event".
1 Continue with existing labels (button1)
2 Create new labels (button2)
What I want to do is if the user presses the top button then presses Start, the code needs to open up the labels worksheet, or if the user chooses the second option and clicks on the start button it opens up the product worksheet. Please help
Thanks in advance - not sure what I am doing wrong!!