View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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