View Single Post
 
Old 01-30-2016, 08:45 AM
fairchance fairchance is offline Windows 8 Office 2010 64bit
Advanced Beginner
 
Join Date: Jun 2015
Posts: 54
fairchance can only hope to improve
Default Output based on Combo Box selected items in Microsoft Word

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
Reply With Quote