Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting control on userform with part of control name (set question)
I have a select case statement, in which I determine which group of controls
("a", "b", "c", ..."j") I need to update (groups include radiobuttons, checkboxes, etc.); e.g., group "a" includes cb_a, opt_a1T, opt_a1F, opt_a2T, opt_A2F, etc. Without looping through all controls (that would be a lot of extra searching, with one full loop for each control) I'd like to be able to set the control references dynamically, e.g. Select Case Case "Green" Use_group = "a" End Select Set current_opt = "opt_" & Use_group & "1T" '<<< current_opt.value = false Can anyone point me to the correct syntax to directly select a control based on control name? Many thanks, Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Control for selecting cells in worksheets | Excel Programming | |||
Syntax for de-selecting a control? | Excel Programming | |||
Control Sequence from Userform Control | Excel Programming | |||
Flow of control in VBA Question - Userform Interaction | Excel Programming | |||
Selecting dates from ListBoxes by using RefEdit Control | Excel Programming |