Hello -
I am a novice at VBA but I think I need it to do the following.

This pertains to a form I am creating that needs content controls for text as well as calculations and need the text controls to be able to be spell checked. (I know Spell check cannot be run on Legacy Controls)

I would like a combo box content control to that once selected retains a value to be calculated while showing the text chosen.

For example:
Choices would be Excellent, Average, Below Average the values would be 20, 10, 5 respectively. I would have several of the combo boxes and at the end I would like to take an average of the selections.

I have the table set-up and searched the forum for answers but have not found anything like this or maybe I am to novice to understand the VBA presented.

Thank you for any assistance