Modules in Excel

[WOTRAC]

Hi

I have created a new module in Excel, containing code for data access.
I want to put a combo box on the first sheet in the workbook, which will display records returned from the accessed data.
How do I reference the Procedure in the module from the combo box.

 

[PHV]

If the combo is created from the ControlToolBar, right click inside the combo and click Show code option of the popup menu.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[WOTRAC]

Sorry if my description was a bit vague.
I was trying to run the code in the module from the combo box on the spreadsheet.

It turned out that I had declared my procedure as private, when I changed it to public it worked fine.
I wanted to know if there was another way to achieve the same result