ukdane
11-12-2008, 03:36 PM
Excel 2000.
I have a workbook that contains 1 worksheet ("Datalist") which has a named region "Equipment".
Worksheet 2 ("Sheet2") containes a dropdownlist (Cell O3), which lists the items in Equipment.
I have a form, which contains a combobox. When the form activates, I want it to default to show the data on sheet2 (Cell O3). BUT I want the combobox items to list the contents of "Equipment", on the Datalist sheet.
How do I set these parameters?
Cheers
I have a workbook that contains 1 worksheet ("Datalist") which has a named region "Equipment".
Worksheet 2 ("Sheet2") containes a dropdownlist (Cell O3), which lists the items in Equipment.
I have a form, which contains a combobox. When the form activates, I want it to default to show the data on sheet2 (Cell O3). BUT I want the combobox items to list the contents of "Equipment", on the Datalist sheet.
How do I set these parameters?
Cheers