Using a ComboBox Control in Excel

[scottydel]

Hello,

I'm using Excel 2003. I have added a combobox to Sheet1. I would like to
know how to access that control both from the code behind Sheet 1, as well as
another module in the Modules folder.

I am a little more used to Access VBA and Windows Forms, and there it is as
simple as something like:

Forms("formName").Controls("controlNname").Property/Method


I have used the object browser but haven't found a similar "Controls"
collection to locate my combo box.

Any help would be appreciated!

Thanks,

-Scott

 

[Dave Peterson]

If I want to clear the combobox, I could use this:

Worksheets("sheet999").ComboBox1.Clear
or
Worksheets("sheet999").OLEObjects("Combobox1").Object.Clear