Changing Option Buttons status
If you know the names of the optionbuttons (from the Control toolbox toolbar,
right?):
With Worksheets("othersheetnamehere")
.OptionButton1.Value = False
.OptionButton2.Value = False
.OptionButton3.Value = False
End With
If the optionbuttons are from the Forms toolbar:
With Worksheets("othersheetnamehere")
.OptionButtons("Option Button 1").Value = xlOff
.OptionButtons("Option Button 2").Value = xlOff
.OptionButtons("Option Button 3").Value = xlOff
End With
Fan924 wrote:
I have 3 Option Buttons on a sheet. Can I set the true/false status of
the buttons using a macro from another sheet?
--
Dave Peterson
|