I've used the following in the past. It works for me, but may be a bit
convoluted.
-----------------------------------------------------------------------
Column A2:A21 Values = 1-20
Column B2:B21 Values = List of names

Create a list box with the input range set to B2:B21 and the Cell Link set
to C1.
In D1 enter the formula "=Vlookup(C1,A2:B21,2)
------------------------------------------------------------------------


"Kevin" wrote in message
...
I made a List Box from the Form Menu and input a range of cells
(Notes!$A$2:$A$21) that contain a list of names. What I would like to do
is,
to select a cell and the goto the List Box select a Name and then it would
just copy that name to the previously selected cell. Is this possible? or
way to complicated to mess with.
At the moment all I do is select the name from the List Box and the type
the
name into the cell! Its just a list that helps me remember all the names.

Thank you in advance for all your help!

Kevin Brenner

Thank you guys for your help, I'll try it in the morning

Kevin

"Tumbleweed" wrote in message
...
I've used the following in the past. It works for me, but may be a bit
convoluted.
-----------------------------------------------------------------------
Column A2:A21 Values = 1-20
Column B2:B21 Values = List of names

Create a list box with the input range set to B2:B21 and the Cell Link set
to C1.
In D1 enter the formula "=Vlookup(C1,A2:B21,2)
------------------------------------------------------------------------


"Kevin" wrote in message
...
I made a List Box from the Form Menu and input a range of cells
(Notes!$A$2:$A$21) that contain a list of names. What I would like to do
is,
to select a cell and the goto the List Box select a Name and then it
would
just copy that name to the previously selected cell. Is this possible?
or
way to complicated to mess with.
At the moment all I do is select the name from the List Box and the type
the
name into the cell! Its just a list that helps me remember all the
names.

Thank you in advance for all your help!

Kevin Brenner