Drop List with a description but once chosen description disappear

Hello,

I was wondering is there a way to create your drop list where in the drop down it has the Ingredient and description of Ingredient but once I choose my option it just display the Ingredient and not the description. For example, in the drop list (when the arrow is clicked on) it has:

Eggs - yellow yoke
Broccoli - green vegetable

but once I choose Eggs, it just display "Eggs" in the cell and not "yellow yoke".

Is it possible?

I'm not to good with VBA.

Yes this could possibly work! How do I go about doing this?

Why don't you give it a shot in a sample workbook and if you have questions once you have set things up post them back here?

sounds great I will try it out now!

This link is perfect for what I am trying to do. I tried to create a sample of my own and just use their coding instead of recreating the whole thing but I'm having trouble getting it to run. I watched Youtube tutorials on how to create VBA in excel but keep running into road blocks.

Can you post what you have so far? Or even just a sample with what you are working with?

Hello I'm trying to attach my document but for some odd reason my file will not attach even after I followed the steps provided previously.

It attached. So you want a drop down menus that when you select a product, in an adhacent cell the description and number will appear? Do you want this in a pop up window? On on the sheet itself

Yes that is correct, and on the sheet itself please.

Yes that is correct, and on the sheet itself please.

see if this does what you would like?

When I try this code and click "Run", it brings up the screen "Macro Name" which I thought I already created a name. I'm not understanding why it will not Run.


Public Sub my_macro(ByVal Target As Range)

If Target.Cells.Count > 1 Then GoTo exitHandler

If Target.Column = 2 Then
If Target.Value = "" Then GoTo exitHandler
Application.EnableEvents = False
Target.Value = Worksheets("Codes").Range("A1") _
.Offset(Application.WorksheetFunction _
.Match(Target.Value, Worksheets("Codes").Range("ProdList"), 0), 0)
End If

exitHandler:
Application.EnableEvents = True
Exit Sub

End Sub

Well I'm really not sure what your doing there or where that code came from?

even when i try to follow your example that you provided to me in the "Dynamic combobox and listbox" it still prompt me to enter a Macro Name. I'm going to list the steps I take and can you tell me if I miss something.
1. Open Workbook
2. Proceed to VBA
3. Insert Module
4. Begin typing "Sub Worksheet_Change(ByVal Target As Range)
5. Press Enter
6.Begin to type the code you provided
7. Save Macro and Workbook as .xlsm
8. Proceed back to module, place cursor somewhere between my code
9. Run Macro.

Well you need to add the list and text boxes. And have them labeled properly. And you have to make sure you have the named range proper as well. If your. It strong with VBA taking what I have done and incorporating it into your own workbook might be hard for you of any of the ranges of data are different. Or the layout is different. Hence the reason why everyone here will suggest you alway provide a sample book clearly indicating what you have and expect to see. All you showed was an example of what you wanted via pic and then some simple sample data?

Got it to work! Thanks so much for your help!! They were labeled improperly.