option buttons' values = false

  • Thread starter Thread starter Spencer Hutton
  • Start date Start date
S

Spencer Hutton

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.
 
Spencer,
try this

For i = 1 To 100
ActiveSheet.DrawingObjects("option button " & i) = False
Next i

Neil
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Need Macro to Sum Range and Paste the Value into one Cell 2
Changing Option Buttons status 5
Taking control from Option Button into RefEdit in Excel 2010 behaving oddly 4
Retain value of userform option button 3
Getting Excel Find to Default to Searching Workbook not Sheet 3
Macro Related to Paste Values 2
Find sometimes ignores Application.FindFormat 3

Back
Top