Using ComboBox to fill data in cells of sheet1 from sheet2

[tiemann66]

Hello,
I am new to VBA. I have done some VBA in excel before like adding command buttons to send a copy of .xlsm workbook as an .xlsx file as an attachment in an e-mail and calling data from the workbook to fill Subject and Body with data from cells of the .xlsm workbook. I found example code online in multiple locations and modified it to fit my need.

What I am trying to accomplish yet have not found much help online is to have a workbook that has multiple sheets but only 2 of them will be used (this is for quoting a product with multiple option selections to a customer). What I want to do is on the quote sheet is to have combo boxes in each of the Part Number cells that get their list form the options sheet column B part numbers. Now when you select one of the part numbers from the combo box I want to be able to call the data from that part numbers cells that hold the description and unit price and then copy the description and unit price to the 2 corresponding cells of the row the combo box is in on the Quote sheet. The combo box will be the part number displayed on the quote sheet and the user can fill out quantity and formulas will calculate the rest.

I have attached an example workbook that has no code. The Quote sheet is blank for the most part and the Options sheet has 10 example part numbers. Thanks in advance for any help.

[tehneXus]

This one goes without VBA using data validation and VLookup: Example ComboBox Selection.xlsm

Regards

[tiemann66]

I did end up using Data Validation to setup my drop down box with a Named column from another worksheet and then used the "INDEX" formula to fill cells with the corisponding info from another sheet. Thanks for replying.
This is the INDEX command I used.

Please Login or Register  to view this content.