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