Dear All Colleagues,

I need help about Word VBA. I have word document and need to add combo boxes containing five list items i.e. Excellent, Very Good, Good, Below Average, Poor. When I select the list item the following output is desired:

Excellent; 1 ( Font color Green)
Very Good; 2 (Color Green)
Good; 3 (Color Orange)
Below Average; 4 (Color Red)
Poor; 5 (Color Red)

I need this corresponding word on the same page when selected any item in combo box. Here is the screenshot of the same:



http://prntscr.com/9wtr5s

There are 11 sections which will contain same combo boxes and their output will be screened on summary page. The view of the summary page is as follows:

http://prntscr.com/9wtlfr

Score achieved will be added on summary sheet after selecting combo box item of each section page. I hope you understand this requirements.

Please help