Clear Option button from userform

[Doflamingo]

Hi all,

I try to understand why my code to clear option button does not work.

I know how to clear listbox or textbox from userform, code below

ListBox2.Clear
TextBox1 = ""

But from various optionbuttons in frame, it does not work

Here I have 2 frames, with 4 option button in the 1st frame and 11 optionbutton in the 2nd frame

The code to clean optionbutton below does not work. I have not renamed them, they are called optionbutton1, optionbutton2 etc...until optionbutton15. Same thing for the frame: Frame1, Frame 2

For i = 1 To 2
      For Each c In Controls("Optionbutton" & Format(i, "00")).Controls
        c.Value = False
      Next c
Next i

Any idea ?

 

[Fluff]

Try

   For i = 1 To 5
      Controls("OptionButton" & i) = False
   Next i

 

[Doflamingo]

Hello @Fluff

Many thanks for your answer. It works for some option button but not for all of them.

For instance if I select optionbutton1 (1st frame)and optionbutton5 (2nd frame) and then activate the commandbutton of your code. Yes that cleans the 2 optionbuttons selected.

But if I select optionbutton1(1st frame) and optionbutton6 (2nd frame) and then activate the commandbutton of your code. It only cleans the optionbutton1 and not the option button 6.

Any ideas ?

 

[Doflamingo]

Sorry @Fluff

Your code works perfectly. I should have precised that I had 15 option buttons

so here is the code

For i = 1 To 15
      Controls("OptionButton" & i) = False
   Next i

Many thanks for your help and your time

Kind regards

 

[Fluff]

You're welcome & thanks for the feedback