If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
want a list of selectable names on my worksheet
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 |
#3
|
|||
|
|||
want a list of selectable names on my worksheet
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 |
#4
|
|||
|
|||
Thanks! want a list of selectable names on my worksheet
Thank you! I'll give it a try and let you know.
Boze |
#5
|
|||
|
|||
Worked! 2nd Question
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. |
Thread Tools | |
Display Modes | |
|
|