Hi,
I have a few option buttons for the calculation of my worksheet. When I select one option button of a group another option button of the other group remains selected.
I am using the below code.
Code
Sub OptionButton12_Click()
Range("N27").Value = "=Today()"
Range("N28").Select
Range("N28").Value = "Date Here"
Range("N30").Value = "Please Enter Forward Date"
End Sub
Is it possible, when I select "option Button 12" then Option Button 63 to 68 will be unchecked? and if I enter any date manually in Cell N27 Option Button 12 and 13 will be unchecked as well.
Thanks in Advance.