MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combo box - List Fill Range question - REPOST, HELP!!!


Posted by Erwin on September 27, 2001 11:36 AM

In the properties section, the list fill range section is referencing an excel range on an external server. My problem is that combo box only populates when the excel file is open. Is there a way to populate this without having to open up the file in the process.

Thanks in advance


Posted by Juan Pablo on September 27, 2001 12:07 PM

If the source is variable then yes, you have to open the file, if not, you can set them as a hidden range, an array, or something else.

Juan Pablo

------------

Posted by Erwin on September 27, 2001 12:26 PM

Juan,

Can you provide me with information on how this is possible. Thanks!

Posted by Juan Pablo on September 27, 2001 12:43 PM

The simple one, copy onto a hidden sheet in your workbook the same list that the combobox is looking for, for example if the list is looking for the file Template.xlt, Sheet1 and range A1:A200, copy this (A1:A200) to a new sheet in your workbook. (For example, Sourcesheet)

Now, in the Combo Box, in the control source type:

Sourcesheet!A1:A200

And your ComboBox should be ready to work.

Juan Pablo