group/frames
 

Hi

I have a frame that has a number of option buttons in it.
Is there any way I can set all these to false with one
line of code, by referencing the frame?

group/frames
 

Libby,

I don't believe this is possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"libby" wrote in message
...
Hi

I have a frame that has a number of option buttons in it.
Is there any way I can set all these to false with one
line of code, by referencing the frame?

group/frames
 

You can, however, use a loop structure to reset all the option
buttons to false.

Dim Ctrl As MSForms.Control
For Each Ctrl In Me.Frame1.Controls
If TypeOf Ctrl Is MSForms.OptionButton Then
Ctrl.Value = False
End If
Next Ctrl



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Chip Pearson" wrote in message
...
Libby,

I don't believe this is possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"libby" wrote in message
...
Hi

I have a frame that has a number of option buttons in it.
Is there any way I can set all these to false with one
line of code, by referencing the frame?