Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
Option buttons: How to get the selected option from a group? | Excel Programming | |||
Changing text size in option buttons on a userform | Excel Programming | |||
Navigating between option buttons is not selecting the option | Excel Programming | |||
Navigating between option buttons is not selecting the option | Excel Programming |