Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Did you find the sheet that didn't have it/them?
If the names are wrong, then you may not end up with what you want. But if you don't care, you can just do the work and ignore any error. Sub SelectSW3() Dim s As Long For s = 2 To ActiveWorkbook.Sheets.Count With Worksheets(s) on error resume next .OptionButton1.Value = False .OptionButton2.Value = False .OptionButton3.Value = True on error goto 0 End With Next s Beep End Sub Fan924 wrote: Can I test for the presents of OptionButton1, OptionButton2, and OptionButton3 on each sheet so I can skip that sheet and go to the next? -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Programming | |||
Change isAddin to false or true | Excel Programming | |||
TRUE/FALSE BOX not activating a WS change | Excel Discussion (Misc queries) | |||
Change optionbutton to true for good | Excel Programming |