P
Philosophaie
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?
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?