Assigning a Combo box selection to numerical value in text box

[Westwisco]

I am trying to assign a numerical value to a selection made in a combo box in a userform I have created. When the selection is made, a numerical assigned to the selection would then be shown in the text box next to the combo box on the userform.

This is what I have so far:

Please Login or Register  to view this content.

If the user selects "Pulp and Paper" I want a numberical value (say 15), to show up in a text box next to the selection in the userform.




I don't have a representative workbook at this point. I am just building a simple userform in which I can have multiple combo boxes that will allow selections, each applying a value to the text box next to it. At the end, the text boxes will be added and this total will be applied back to a cell in one of the worksheets.

Any suggestions on how I can do this?

Thanks!!!!
Westwisco

[jwright650]

Don't forget to add the code tags around your code in the first post per the forum rules.

Also attach a representative workbook to give a better idea of what you have going on.