View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paolo Sardi Paolo Sardi is offline
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.