View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Philosophaie Philosophaie is offline
external usenet poster
 
Posts: 110
Default Initilizing the New DropDown feature

Having a little trouble initilizing the New DropDown1 that came up when I
inserted the ComboBox (Form Control). Here is the code used in ThisWokbook:

Private Sub Workbook_Open()
With DropDown1
.AddItem "Current Date"
.AddItem "Enter Date"
.Caption "Select Date Type"
End With
End Sub

It didn't like the (.AddItem "Current Date") and marked it in yellow for
debug. Can someone help me with the syntax?