Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Pull down menu - Combo box

Pull down menu - Combo box

Pull down menu - Combo box

Hi all, I have another question which I think some of you guys can halp me with.
I wanna create pull down menu or combo box  with multiple entries.  For example I wanna create spreadsheet with daily working hours for each day ie I am trying to put up a combo box with the names of all employees, so that we don't have to type their names each time, but just select name from the combo box.
Any clues what would be the easiest way to do that.

RE: Pull down menu - Combo box


I think what you should probably use is the standard Excel Data|Validation menu.  Just have your staff names listed (in a named range, for instance) and apply Data Validation to the cells.  Look up Excel help on "data validation" for more details.



RE: Pull down menu - Combo box

Thanx briand2 for the tip, I'll try that

RE: Pull down menu - Combo box


Create your combox box, then right on it to display properties. You will see a property called ListFillRange. This is where you can enter the range of cells you want the combo box to show selections. For example, if all your names are in cells A1 to A20, then this property can be set to that range of cells. I prefer to  create a named range and use that name for the ListFillRange property.

RE: Pull down menu - Combo box

Thank you very much guys for your time, I've done it and it makes life much easier.
Thanks again

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close