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.
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.