| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide my combo boxes! | Excel Discussion (Misc queries) | |||
| Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
| connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
| dynamic combo boxes | Excel Worksheet Functions | |||
| How do I autofill combo boxes with their destination cell? | Excel Worksheet Functions | |||
Linear Mode
