×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

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!
  • Students Click Here

*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

Jobs

Using a combo box in excel

Using a combo box in excel

Using a combo box in excel

(OP)
I am using a combo box to pull a list from another sheet within the workbook. What I would like to do is have the rest of the data in that row follow with the choice that was made in the combo box. For example I pick the equipment type and the cost/hr, cycles/hr, floor space/req follow and fills in the row. How do I do this?

RE: Using a combo box in excel

The combo box will provide you with the index of the item selected in the linked cell (how you specify that is dependent on which combo box you have used: the one from the control toolbox or the one from the forms toolbar)

So if you pick the first item in the list, the value of the linked cell becomes 1, etc.

Then, using the INDEX function, you can return any cell in the proper row. So if your list is on Sheet2!$A$1:$H$20, and the linked cell is on Sheet1!$A$3, the functions should read:

=INDEX(Sheet2!$A$1:$H$20, Sheet1!$A$3, 1) to return the data in column A of Sheet 2,

=INDEX(Sheet2!$A$1:$H$20, Sheet1!$A$3, 2) to return the data in column B of Sheet2, etc.

Regards,

Joerd

RE: Using a combo box in excel

I achieve this by using the combo box and the vlookup function together.

It is much the same as JOERDs response.

regards
sc

RE: Using a combo box in excel

Very useful post, everyone.

I had combo boxes with vlookups, but changed them to the more succinct INDEX function formulation.  It saves you from having to input columns of numbers or labels to the left of your range, only for indexing purposes!

Free tip:  To make changes to a group of worksheets in an excel file, before making the change in the active sheet, hit ctrl and click on all the sheet tabs you want to affect. After making whatever change (incl. setting up Headers/ Footers), right click on one of the affected sheet tabs and select Ungroup Sheets.

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!


Resources