Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing an activex control property using a macro
You could pass it as a generic object:
Sub BigCode(myControl as Object) If you were only passing comboboxes from the control toolbox toolbar (placed on a worksheet), you could pass it as a combobox: sub bigcode(myCombobox as msforms.combobox) This would work if your combobox was on a userform, too. Sian wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change activex control properties from a macro | Excel Discussion (Misc queries) | |||
Can I control linked cell property value in a copied ActiveX contr | Excel Discussion (Misc queries) | |||
Linked Cell Property In Activex controls | Excel Discussion (Misc queries) | |||
How do I link a macro to an ActiveX control? | New Users to Excel | |||
How do I link a macro to an ActiveX control? | New Users to Excel |