You can add a combo box to a spreadsheet without using a user form. You can select it from the Visual Basic menu. If you right click on the top menu, you can select it here, or go to VIEW-TOOLBARS and select VISUAL BASIC. Here is a macro that you can adjust and use that will add a combo box:
Sub AddBox()
ActiveSheet.OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, _
DisplayAsIcon:=False, Left:=240.75, Top:=65.25, Width:=94.5, Height:= _
12.75).Select
Application.CommandBars("Control Toolbox").Visible = False
End Sub
This message was edited by Scott on 2002-04-16 15:03