If ComboBox1 = Text Then Show List name in TextBox

Good day,
Looking help for the following:

In a UserForm, I have a comboBox with a list of names...Lets say John Doe and Joe Dane. I need that if a user Select, lets say John Doe then the TextBox will populate another Text vs that name.

Example:

John Doe = HS321
Joe Dane = HS123

If the user select John Doe Then HS321 will be inserted in the TextBox
If the user select Joe Dane Then HS123 will be inserted in the TextBox

Is there a special way to do this in VBA and not by hidding the name and id tag in a new worksheet?

Thank you,

Found my own Answer...lol

Code:

Please Login or Register  to view this content.