filling combo boxes from single outer source
 

Hi,
I want to make a template with combo box on sheet 1. I can fill values for
combo from sheet 2 for example. But that way I'll end up with every single
file (made from that template) also with sheet 2 and all the stuff in it.
Is there any way I can store source for combo values out of template?
Thanx

filling combo boxes from single outer source
 

You could still place the lookup values on sheet 2, but instead of hard
coding the values you could place formulas that link back to a globally
available workbook where the lookup values are maintained.

Additionally, you could name the range containing the combobox lookup values
and have a macro automatically read the range in upon opening.

Hope this kinda' points you in a useful direction...
--
Kevin Backmann


"alekm" wrote:

Hi,
I want to make a template with combo box on sheet 1. I can fill values for
combo from sheet 2 for example. But that way I'll end up with every single
file (made from that template) also with sheet 2 and all the stuff in it.
Is there any way I can store source for combo values out of template?
Thanx