Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |