Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
Dropdown box display only data dependent on another dropdown box? | Excel Worksheet Functions | |||
Dropdown List within a dropdown | Excel Worksheet Functions | |||
populating a dropdown based on choice from a previous dropdown | Excel Programming | |||
offer dropdown options based on another dropdown | Excel Discussion (Misc queries) |