Drop down lists


Posted by EDB on August 01, 2001 2:34 PM

Is it possible to create a drop down list on an excel spread sheet and if so how?

Thanks.

Posted by Jim on August 01, 2001 2:46 PM

EDB yes it is, try this:
Option Explicit
Private Sub Control_On_Worksheet()
Dim My Pick As Variant
With Worksheets("Your WS").DropDowns("My Control")
mypick = .ListIndex
ActiveCell.Value = .List(mypick)
.Value = 0
End With
End Sub
Jim



Posted by Cory on August 01, 2001 2:48 PM

Sure!

Go to View --> Toolbars --> Visual basic

On the VB toolbar pick the tool box. Hover over the controls until you find combo box. Click anywhere on your form to place it. To fill it with your selection choices, list them in a column (say col A). Now right-click on the combo box and choose properties. Scroll down until you see ListFillRange. Type in the range that contains your selections (A1:A10 for example). Close the properties box and, on the VB toolbar, de-select the blue triangle (take it off design mode). Now when you click the drop arrow, your selections should be there...

Hope this is what you were looking for...

Cory