View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Neil[_24_] Neil[_24_] is offline
external usenet poster
 
Posts: 15
Default 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.