Hi,

I'm using the "DropDown" object based on it's usage in "Excel 2002 VBA Programmers Reference" page 208. The text states that this is a hidden member of the Excel object model. So can anyone point me to some *secret* documentation on it? I need to know how to remove items from the DropDown box. The text shows how to add, and just a couple of other properties/methods. I'd like to know more...

Thank you,

Robert Stober

Okay, I found almost everything I need in the object browser (after showing hidden items) and by trial and error, but I still need to know how to cause one of the list items to be selected (showing in the box as soon as it's drawn) by default.

I want the box to read "Select". Right now it's just blank, although clicking on the control shows the itms in the list. I want to make it more intuitive...

Thank you,

Robert Stober

Assuming that "Select" is the first item in the list, the solution is:

With ActiveSheet.DropDowns(1)
 .Value = 1
End With