VBA / MACRO Scrolling scale or radio button scale

[alsbc]

Hi

I would like a scale for the suer to select appropriate grade going from 1 RED, 2,3,4 5 (AMBER) 6,7,8,9 10 Green

This could be ideally a scrolling slider to select or radio buttons maybe ?

Does anyone have any ideas I could use?

[macropod]

You could use a dropdown content control with the appropriate values and a suitably-coded ContentControlOnExit macro. For some code to get you started, see: http://www.msofficeforums.com/word-vba/16505-change-color-according-dropdown-selection.html#post47254