With Excel 2000, I have added a combo box control to my worksheet and named
it "myCombo1". In this combo box, there are 5 items. How do I use VBA to
select this combo box and automatically have it drop down using VBA? In
Microsoft Access I would use the "Dropdown" method of my combo box. However,
in Excel, I have not been able to find an equivalent. I have done the
following to select my combo box, but can't find a Dropdown method:

Worksheets("myWorksheet").DropDowns("myCombo1").Se lect