VBA code for assigning a numeric code to text; then numeric code populates table

[cteaster]

I have an ActiveX combo box with several different options that are text (Educational Endorsement, License, etc.). The text options have numeric codes associated with them; therefore, I would like for the selected "text" to be converted to the corresponding numeric code (i.e. Educational Endorsement = 1 and License =2) and have the numeric code (1, 2, etc.) entered into a table. Currently, the text is entered into the table rather than the code.

Thank you for your help.

[stnkynts]

You gave no cell references so I will have to assume. Also, there has to be a way to tell the code what text gets assigned to what value. This can be done directly in code or in a seperate cell range/worksheet. I will show in code (because it takes less of my time) and I will make assumptions on cell references (because it takes less of my time). Copy and paste to proper combobox:

Please Login or Register  to view this content.

[cteaster]

Thank you!