Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
OptionButton | Excel Programming | |||
OptionButton | Excel Programming | |||
Better Way to Use OptionButton | Excel Programming | |||
Better Way to Use OptionButton | Excel Programming | |||
which optionbutton is on | Excel Programming |