Populate Combobox with data from seperate workbook

[kemit]

Hi, I would like to populate a Combobox with data contained in a separate workbook.

The workbook is Busstops.xlsm and the range is "stopnames"

thanks

[kasan]

Right click on Combobox - Format Control. On tab Control in Input range: write =stopnames

[kemit]

Hi kasan, I do not follow what you are saying here

[bakerman2]

@ kemit

Please close your other thread regarding the same issue.

[kasan]

kemit,
Are you using Form Control Combobox or AxtiveX Combobox? It would be better if you could upload sample file with your combobox and range of values you wish to populate

[kemit]

I initially wanted to use a Userform with the combobox in it but if a form control combobox will work then I will use it. The problem is that the sheet on which the combobox is in a totally separate file (Model.xlsm) to where the data is stored in (Busstops.xlsm).

[kemit]

Attached are Model.xlsm and Busstops.xlsm

I sheet1 of model when one clicks in column c & d I want the combobox to appear but it must be populated with the list of stop names that is contained in the range "Names" which is in the Busstops file. this is the code that I have been using for test purposes.

Please Login or Register  to view this content.