Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a control (a list box) embedded in a worksheet. I'm trying to access properties and methods of this control from a sub in a module. I discovered that I can call ListBox1.AddItem from code IN THE SHEET but if the same code is in a module it gives me an error (in my case is "Variable not defined" since I used "option explicit"). Apparently the control is not recognised in a sub. How can I access control properties from within a module? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Control Box Properties | Excel Discussion (Misc queries) | |||
Spinner Control Properties | Excel Worksheet Functions | |||
Control Properties | Excel Programming | |||
ActiveX Control Properties | Excel Programming | |||
Change Control properties in VBE | Excel Programming |