for each optionbutton
 

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

for each optionbutton
 

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


---
Regards,
Norman



"masterphilch" wrote in message
...
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