On 2002-01-14 12:33, LMF wrote:
Did you create the ComboBox using View|Toolbars|Forms?
Yes
If so, what is its input range and cell link?
Input range is just saying select list AAA or BBB to be appeared to the list box.
Does the input range of your combobox contain the list names AAA and BBB?
yeah!
I wished I had more specific answers to the above questions. What follows will describe how to connect a combobox with a listbox.
We have a range (preferably in a worksheet called
Admin), which is
named CList, housing the following items:
AAA
BBB
Again, we have in
Admin two ranges which are
named AAA and
BBB.
In a worksheet, named say
Main, create a combobox, using the option View|Toolbars|Forms in B2, with
CList as Input range and with B2 as Cell link.
Activate the option Insert|Define|Name.
Enter
CurList as name in the Names in Worbook box.
Enter as formula in the Refers to box:
=INDIRECT(INDEX(CList,Admin!$B$2))
Activate OK.
Create a listbox in E2 in
Main, using the option View|Toolbars|Forms, with
CurList as Input range, with E2 as Cell link, and Selection type set to Single.
That's all.
Aladin