changing an activex control property using a macro
Here's the thing: I have one large procedure (BigCode) which I call from
many different small procedures:
call BigCode (mycontrol, 1)
'mycontrol' is the name of an activex control.
One of the things I want Bigcode to do is change properties of mycontrol,
for example
With mycontrol
.Locked = True
End with
My question is what do I pass as mycontrol? Or how to I get BigCode to
understand it's the control itself I want to change (at the moment every
variable translates to eg "Combobox1" (in quotes)
Help greatly appreciated!
Sian
|