List Boxes

  • Thread starter Thread starter W.L
  • Start date Start date
W

W.L

I know how to create a list box and I know how to create
the cell link but what I want to do and I don't know how
is create multiple links. example

Column 1

cell A2 = ITEM - LIST BOX

CELL A4 = ITEM NO - This is where I have created the cell
link so
CELL A5 I want to know when a user selects from the list
box it will show the coresponding number here as well, the
same for cells A6-A8
CELL A6
CELL A7
CELL A8

How do I do this can anyone help I have looked in books
glore and I still don't know how. I hope I make sense.

Appreciate any help anyone can give me.
 
If I understand correctly, set A5 as the =INDEX(B1:B100,A2,1) where B1:B100
is the input range. Then set A6 =A5, etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Column 1
cell A2 = ITEM - LIST BOX

CELL A4 = ITEM NO - This is where I have created the cell
link so
CELL A5 I want to know when a user selects from the list
box it will show the coresponding number here as well, the
same for cells A6-A8
CELL A6
CELL A7
CELL A8
Click to expand...

Wendy

AFAIK this can not be done directly. But if you want to
replicate A4s value in A5 type =A$4 and copy this down.

Regards
Peter
 
Back
Top