Create Drop Down List Within A Form

**lvmineoster21** · 06-10-2009, 03:09 PM

Hi All!

I am working on a form on excel to allow a secretary to log hours into excel. But instead of having her type in each name, I want her to be able to choose them from a list. So for example, when you do Data>Forms, the category under "name", would be a drop down menu so you could pick a name, and enter the amount of hours worked. Any help would be great!

Luca

**starryknight64** · 06-10-2009, 03:35 PM

Try doing this:

Click on the cell you're normally used to typing the name into.
Goto Data-->Validation...
In the "Allow" drop box, click List
In the "Source" text box, type in the names (delimited by commas) you want to select from. (i.e. Sally,Joe,Billy)
Make sure "In-cell dropdown" is checked.
Click OK

I hope this helps!

**highbarger** · 06-10-2009, 04:04 PM

Create a Combo Box in the userform. Find the Row Source field in the Properties Window. If the data that you want to show up in the drop down list is in a named range, just put the name in Row Source. Otherwise, put the range in there. Something like A2:A38

Hope this helps.

Craig

**lvmineoster21** · 06-11-2009, 09:19 AM

Thanks for the quick responses! I tried using both your suggestions, but I still can't seem to get exactly what I need. I've posted a screenshot of where I want the drop down list. Hopefully you guys can get a better idea of what I'm talking about. Thanks in advance!

Luca

\1
By chucas11 at 2009-06-11

**starryknight64** · 06-11-2009, 10:47 AM

Ah! ...fun times...

Alright, just goto your Toolbox. Inside there should be a combobox. You'll just need to instantiate one of those and populate it with the names of the people you want to enter.

Try something like this (assuming your combo box is named ComboBox1):

Please Login or Register  to view this content.

I hope this helps!

**highbarger** · 06-11-2009, 05:20 PM

If your list of employees is very long it will be faster to name the range that contains the employee names that you want to appear in the userform. Here is a screenshot that shows an example.
\1

Then just put the name of that range in the row source of the combobox.
\1

I hope these samples make sense and help you achieve your goal.
Craig

**Art Vandalaye** · 02-11-2011, 10:43 AM

Hi all - I successfully created a form with a combo box and used this forum to find out how to add values to it (values are: Provider, Beneficiary and other).....and when I put the range N:N in the ROW SOURCE in the properties window, I even see the 3 values in the combo box when I view the code and object in the VBA view........however when I get out of the vba and save everything and then try to run the form I don't see my 3 values. Please help.
Thank you in advance.
Jason

**royUK** · 02-11-2011, 11:07 AM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.