Cross-posted at: https://social.technet.microsoft.com...003?forum=word
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Gmayor's macro works beautifully. Now I am wondering why I can't change the font color on the dropdown selection based on its value.

I tried oFF.Result.font.color = vbRed, for example, but got a compile time error of "Invalid Qualifier". Presumably because the way the code is getting to the dropdown value I cannot use the "." notation to manipulate it. Is there a decent text/reference that explains (with examples) how to properly set up and manipulate the font attributes for the dropdown value?

Thanks much,

Fergie