group/frames

  • Thread starter Thread starter libby
  • Start date Start date
L

libby

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?
 
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
 
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

Output from Frames - multiple optionbutton groups 1
Frames Scroll event causing cursor to move to first textbox 2
scrolling 2 frames simultaneously 2
code to check OptionButton selected within multiple frames 1
Bizarre option button behavior 2
Making a frame visible or not using a command button 3
Making Frames Visible (or not) 1
Working with GroupName in a control 1

Back
Top