want a list of selectable names on my worksheet

[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

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" <[email protected]> wrote in message
news:[email protected]...
> 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]

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.

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

[Boze]

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

[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.