Hello all,
I am trying to create a drop down list, using data validation, from sheet "parts". The data is in columns A and B. On the dropdown, which is located in sheet "entry", I need to see the part number and the name of the part. Once selected, the output has to be only the part number.
How do I go about doing that? I have attached a sample workbook.
Thank you in advance.
Hi sentinela,
You can only have a single column in a Validation list but there might be a way to show two parts of the data: Read:
https://contexturesblog.com/archives...rop-down-list/
Let us know if you get this to work for you. It is a little tricky as you need to add the combo box to the spreadsheet and while in design mode set its properties.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your Entry sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Change the line in red to suit your needs. Close the code window to return to your sheet. Make a selection in B2. The macro assumes that the part number will always be 4 digits.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thanks for the reply.
The problem that I am kind of running into is that my other code refers to the result. I have not been able to refer to a combobox.
Being that "EmpID" is the result from the dropdown.Please Login or Register to view this content.
The macro I suggested works in the file you posted. It would be easier to help and test possible solutions if you could attach a copy of your actual file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).
Hi sentinela,
Mumps isn't using a combo box. He is using a Validation box but showing what is in your range on the parts sheet. A very clever work-a-round.
Thank you very much for the help.Originally Posted by Mumps1
Your idea worked. However, I have another problem at hand. I have posted the actual workbook in this thread
https://www.excelforum.com/excel-pro...o-another.html
Thanks again.
Try:
Please Login or Register to view this content.
It works perfectly
Thanks.
You are very welcome.
One other quick question.
If I have more columns in sheet2 (columns 10 thru 17) that I want to display in sheet1 from range c10 thru c17... How can I adjust the code to do that. I tried couple different things to no avail
Your thoughts?Please Login or Register to view this content.
Thank you
Pease attach an updated copy of your file with the additional columns and explain in detail what you want to copy.
I was able to figure it out... It ends up being
Please Login or Register to view this content.
Well done.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks