List box help required please

  • Thread starter Thread starter Newbie1
  • Start date Start date
N

Newbie1

Hello all

I have created a listbox from the forms toolbar so I can populate a cell
from a list.
The list is A1:A10 so I have entered this into the input range.
The cell I want to populate is B6 so I entered this into Cell link.
The list box shows the contents of the list (all good so far) however
When I click on an entry the cell is populated with a number (which
corresponds with its position in the list)
How can I populate the cell with the actual contents of the list cell?

TIA

bemused!
 
Use a LOOKUP function to work with the linked cell.

Say you want to your listbox to show continents starting from B1, ente
sequential numbers beside them starting from A1.

A1 = 1
A2 = 2
A3 = 3
A4 = 4
A5 = 5
A6 = 6
A7 = 7

B1 = Asia
B2 = Europe
B3 = Africa
B4 = Australia
B5 = North America
B6 = South America
B7 = Antartica

Assuming your kinked celll is C1 use this function

=LOOKUP(C1, A1:A7,B1:B7)

Don't forget you can hide the linked cell under the listbox too b
right-clicking it and changing the position to the same cell as th
list box occupies
 
I tried your suggesting but I am still getting 1 to 7 in the linke
cell.
What I want is to display "Asia" etc. in the linked cell.
I tried changing cells A1:A7 to something other than numbers but th
linked cell still continued to display numbers!

Any suggestions

I am using Win Me and Office 200
 
Or you could use (with B6 as the active cell) : Data / Validation / in the
Allow "box " choose List and then in the Source Box select A1:A10.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
The linked cell will always return a number, you can't change that.
However, you can use another cell as a linked cell (say Z1 - you can
hide the column if you wish), then in B6 enter:

=INDEX(A1:A7,Z1)
 
Many thanks

That is what I was trying to do!

Newbie1

A.W.J. Ales said:
Or you could use (with B6 as the active cell) : Data / Validation / in the
Allow "box " choose List and then in the Source Box select A1:A10.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
Click to expand...
 
Back
Top