I want to build an user interface(listbox) in the form level.
Is that anyway I could call a specific function in a class module
level? In the class module I set up connection with the spreadsheet, do
I have to declare and set up the connection in form level as well?
How do I create a list box in the form level when all my data and
connection is in the class module? Please advise ... thank you

Are you developing in VB6 or .net or in Excel. I am puzzeled as to why you
are using a class module. Does the class module instantiate and instance of
Excel or just what. Post some code so we have some idea how to help.
--
HTH...

Jim Thomlinson


"Taurus" wrote:

I want to build an user interface(listbox) in the form level.
Is that anyway I could call a specific function in a class module
level? In the class module I set up connection with the spreadsheet, do
I have to declare and set up the connection in form level as well?
How do I create a list box in the form level when all my data and
connection is in the class module? Please advise ... thank you