LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default How can I access control properties?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Control Box Properties Montana Excel Discussion (Misc queries) 1 August 7th 07 04:38 PM
Spinner Control Properties rpalmer4 Excel Worksheet Functions 1 November 13th 05 09:40 PM
Control Properties Lee Hunter Excel Programming 2 September 10th 04 03:10 PM
ActiveX Control Properties Nigel Excel Programming 7 July 6th 04 07:08 AM
Change Control properties in VBE Sandy V Excel Programming 2 July 30th 03 09:14 AM


All times are GMT +1. The time now is 01:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"