How do I set a combobox listfillrange to a range in another workb.

G

Guest

I have a combobox on sheet1 of workbook1. I'd like to set the combobox
property LISTFILLRANGE to a range in workbook2.
 
D

Dave Peterson

Is the other workbook going to be open?

If yes, you can just go into design mode (another icon on the Control toolbox
toolbar).
rightclick on your combobox
select properties
scroll down to ListFillRange and type in the address--like:

[book2.xls]sheet1!A1:A10

but as soon as you close that other workbook, you break your combobox.

Maybe you could use a formula (on a hidden sheet) to return the values from that
other workbook and use that range for your listfillrange for your combobox.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ComboBox ListFillRange 14
Transpose technique not populating ListFillRange of ActiveX combobox 2
Control ToolBox ComboBox 1
comboboxes 1
Creating a named range? 2
How Do I Load a ComboBox From a Dynamic Range 1
ComboxBox with Dynamically Defined Source, and LinkedCell error 1
Importing named range from another workbook 5

Top