Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Initilizing the New DropDown feature
A couple of things if it is a form control then the code is not applicable!
Set the format of the control as required If you use an Active X Control 1. You need to explicitly reference the ComboBox location, e.g. code below on Sheet1 2. There is no caption property for a ComboBox, if you are trying to set the control to the first entry, use ..ListIndex = 0 Private Sub Workbook_Open() With Worksheets("Sheet1").ComboBox1 .AddItem "Current Date" .AddItem "Enter Date" '.Caption "Select Date Type" End With End Sub -- Regards, Nigel "Philosophaie" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Initilizing the New DropDown feature
How do you initialize a DropDown Box I think that is the question here? "Nigel" wrote: A couple of things if it is a form control then the code is not applicable! Set the format of the control as required If you use an Active X Control 1. You need to explicitly reference the ComboBox location, e.g. code below on Sheet1 2. There is no caption property for a ComboBox, if you are trying to set the control to the first entry, use ..ListIndex = 0 Private Sub Workbook_Open() With Worksheets("Sheet1").ComboBox1 .AddItem "Current Date" .AddItem "Enter Date" '.Caption "Select Date Type" End With End Sub -- Regards, Nigel "Philosophaie" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Initilizing the New DropDown feature
Got it to work with:
Private Sub Workbook_Open() With ActiveSheet.Shapes("Drop Down 2").ControlFormat .AddItem "Current Date" .AddItem "Enter Date" End With End Sub "Philosophaie" wrote: How do you initialize a DropDown Box I think that is the question here? "Nigel" wrote: A couple of things if it is a form control then the code is not applicable! Set the format of the control as required If you use an Active X Control 1. You need to explicitly reference the ComboBox location, e.g. code below on Sheet1 2. There is no caption property for a ComboBox, if you are trying to set the control to the first entry, use ..ListIndex = 0 Private Sub Workbook_Open() With Worksheets("Sheet1").ComboBox1 .AddItem "Current Date" .AddItem "Enter Date" '.Caption "Select Date Type" End With End Sub -- Regards, Nigel "Philosophaie" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |