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