| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to refer to controls by string
Is there anyway to use a control's string name to manipulate it?
At the moment, I have a lot of controls named in a handy manner ("Combobox_A1", "ComboBox_B2", etc.) I often need to be able to change the box based on the "A1" identifier. At the moment, I'm using a loop as follows For each Ctrl in MyForm.Controls If (right(ctrl.name,2) = "A1" then ctrl.value = whatever But it would be nice to simply use the "A1", build the string "Combobox_A1" and then say Control("Combobox_a1").Value = whatever What's the syntax for this? Darren |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Using a txt string to refer to other work book | Excel Worksheet Functions | |||
| ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
| Create a formula into a String then assign string to a cell | Excel Programming | |||
![Darren Hill[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
