want a list of selectable names on my worksheet

Hi

You could use Data/Validation/List. Prepare your list in another sheet and
point your validation at the list.

Hope this helps.
Andy.

"Boze" wrote in message
...
I'd like to have a list box with employees names on my worksheet that has
per diem calculations. I've found the Forms toolbar and put the listbox
on the worksheet but I haven't figured out how I should input the names so
they show in the list AND then how to select a name from the list. Or
maybe a list box isn't what I should use for what I want to do? I would
only need to select one name at a time. Would appreciate any help.

Thanks
Boze

I'd like to have a list box with employees names on my worksheet that has
per diem calculations. I've found the Forms toolbar and put the listbox on
the worksheet but I haven't figured out how I should input the names so they
show in the list AND then how to select a name from the list. Or maybe a
list box isn't what I should use for what I want to do? I would only need
to select one name at a time. Would appreciate any help.

Thanks
Boze

you should use data validation
first select the range of cells where you want to apply the list box
options to select the data from drop down list.
then go to Data Validation under setting tab Allow (select List),
then in source put the range of cells where list of employees' names is
(you must have list of employee names in your worksheet or workbook)
it is better to give Name to your employees' names list. you can do
this by going to Insert Name Define (type "employees" without
quotes and in refers to select range where employees name resides and
press Ok)
now in data validation under setting tab Allow (select List), then in
source put =employees and ok.
now when you select the cell on which you have applied data validation
to put the data, a drop down button will appear, you can select any of
employee name from that list.

hope this would help you.

Boze Wrote:
I'd like to have a list box with employees names on my worksheet that
has
per diem calculations. I've found the Forms toolbar and put the
listbox on
the worksheet but I haven't figured out how I should input the names so
they
show in the list AND then how to select a name from the list. Or maybe
a
list box isn't what I should use for what I want to do? I would only
need
to select one name at a time. Would appreciate any help.

Thanks
Boze


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=568996

Thank you! I'll give it a try and let you know.
Boze

That worked perfectly! What I've got now is a list from which I can select
an employee which is great. I can make a second list where I can select
their postion such as Salesman, VP, Toolmaker which is the other piece of
info I need to display. Is there a way to have ONE list selection that
would put info in 2 cells? Ie, "John" would go in the column under 'Name'
and "Salesman" would go in a column under 'Position'. Seems like a pipe
dream but just wanted to check.

Thanks again for the help with the first list. That's the main thing I
wanted to get setup.