for each optionbutton

  • Thread starter Thread starter masterphilch
  • Start date Start date
M

masterphilch

Hi

I've got a Form with some OptionButtons. Now I preferably want to step
through each OptionButton.
Is it somehow possible to do it like For Each OptionButton In formname?

thx for help
 
Hi MastrPhilch,

Try something like:

Dim Ctl As msforms.Control

For Each Ctl In UserForm1.Controls
If TypeOf Ctl Is msforms.OptionButton Then
'do something, e.g.:
Ctl.Visible = False
End If
Next
 
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

peculiar condition: form optionbuttons lose position and linkedcellon row hide 1
Working with GroupName in a control 1
Dynamically Create and ID OptionButtons, then insert Row; Loop 2
Change event 3
code to check OptionButton selected within multiple frames 1
Enabling/Disabling OptionButtons, CheckBoxes etc. in another works 1
Name OptionButtons from Sheet 4
Code for OptionButton displaying new frame 2

Back
Top