Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Bill,
Does this work?... Application.CommandBars(objJourneyBar).Controls(ob jJourneyDepartCBox).List = _ Worksheets("Sheet6").Range("rgUniqueStations").val ue Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Bill_excelforum" wrote in message I have: (1) a custom toolbar, represented by the object variable objJourneyBar (2) added a combobox control (msoControlComboBox) represented by the object variable objJourneyDepartCBox I have a list of train stations on worksheet Sheet6, column A from row 1 to 3181. I have named that range rgUniqueStations. I have tried a couple of methods to get the list of train stations "into" the combobox on my toolbar, but no joy so far. Appreciate any advice. TIA, Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populating a ComboBox | Excel Programming | |||
Populating combobox/listbox | Excel Programming | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming | |||
Populating ComboBox Methods | Excel Programming | |||
Populating Combobox Methods | Excel Programming |