Thread: Populating combobox in custom toolbar
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill_excelforum[_2_] Bill_excelforum[_2_] is offline
external usenet poster
  
Posts: 1
Default Populating combobox in custom toolbar

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


--
Bill_excelforum
------------------------------------------------------------------------
Bill_excelforum's Profile: http://www.excelforum.com/member.php...o&userid=32280
View this thread: http://www.excelforum.com/showthread...hreadid=526912

Reply With QuoteReply With Quote