Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open and ComboBox
I want to run the following code when my worksheet is open:
--------------------- Sheets("Event Setup").Activate 'Clear ListBox For Count = 1 To ComboBox1.ListCount ComboBox1.RemoveItem (0) Next ComboBox1.AddItem ("<Select Vendor") NumberOfVendors = Range("NumberOfVendors").Value Count = 1 Do While (NumberOfVendors = Count) VendorName = Range("E" & Count).Value MsgBox (VendorName) ComboBox1.AddItem (VendorName) Count = Count + 1 Loop ComboBox1.ListIndex = 0 ------------------------------ I put it in a Workbook_Open macro, but get an error: "object required: on the ComboBox1.ListCount line. How can I run this code when my workbook is opened? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Workbook_Open () | Excel Discussion (Misc queries) | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
Help with Workbook_Open | Excel Programming | |||
Workbook_Open event and combobox state storage question | Excel Programming |