Drop Down Menu
Posted by Sean H. on October 26, 2001 11:31 AM
Hello,
I have two pages within my Excel sheet named page 1 and page 2.
On page 1 I have a drop down menu with the names of my co-workers.
What I want to do is that when a person selects their name on the drop down menu I want their name to automatically appear in a field on page 2.
Can someone kindly tell me how to do this?
I thank you very much in advance,
Sean
Posted by Caleb N. Diffell on October 26, 2001 11:44 AM
Well, I assume you're getting your list for the drop down menu (combo box) from a list of cells somewhere on the workbook. In the combo box's format control, you can choose a "Cell Link" that will return the ROW of your selection in a different cell that you choose. Of course, you don't want the ROW (1,2,3, etc) but the actual name. You CAN do this by giving each row in your original lookup range a corresponding number in the cell immediately to the left of each person's name and then doing a vlookup from the Cell Link cell on that number to return the correct name. There's probably an easier way to do that, but it's what I can think of immediately.
Posted by Sean H. on October 26, 2001 12:19 PM
Thank you for the help but how exactly do I use the VLOOKUP command for this? I have tried a few things but I cannot get it to work.
Thanks again,
Sean
