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
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