| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to refer to controls by string
Darren,
You were nearly there. MyForm.Controls("Combobox_a1").Value = whatever You're probably able to omit the MyForm. Rob "Darren Hill" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to refer to controls by string
Put an "s" on Control
Userform1.Controls("Combobox_a1").Value should work mval = "A1" Controls("Combobox_" & mval).Value = "ABCD" would also be another example. -- Regards, Tom Ogilvy Darren Hill wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to refer to controls by string
Thanks, Tom and Rob. I was pretty close wasn't I? )
-- Darren |
| Reply |
| 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)
Linear Mode
