| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
option buttons' values = false
i have 100 option buttons on a sheet, is there a loop that can set all of
there values to False? i can't seem to get the syntax. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
option buttons' values = false
Spencer,
try this For i = 1 To 100 ActiveSheet.DrawingObjects("option button " & i) = False Next i Neil "Spencer Hutton" wrote in message ... i have 100 option buttons on a sheet, is there a loop that can set all of there values to False? i can't seem to get the syntax. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check box - true/false - i'd like a third option n/a | Excel Discussion (Misc queries) | |||
| Option Buttons/Radio Buttons | New Users to Excel | |||
| TRUE/FALSE MACRO using Option Buttons | Excel Discussion (Misc queries) | |||
| Hide Buttons when a Cell is False | Excel Discussion (Misc queries) | |||
| Controlling numerical values of option buttons in a group? | Excel Discussion (Misc queries) | |||
![Spencer Hutton[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
