View Single Post
 
Old 07-30-2018, 12:48 AM
MP1989 MP1989 is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Jun 2018
Posts: 9
MP1989 is on a distinguished road
Default VBA to provide text string with specific formating based on Drop down list (content control)

Hi all,

I am trying to create a drop down list (content control) and then based on the selection (high, significant or Low) produce text but with some formatting;
'High' = High / Significant / Low (High in bold, significant / Low with strikethrough)
'Significant = High / Significant / Low (Significant in bold, High / Low with strikethrough)
'Low' = High / Significant / Low (Low in bold, High / Significant with strikethrough)

I don't seem to be able to do this in the content control box, but I may be doing something wrong so though about VBA? I don't appear to be able to apply formatting simply (copy and paste) and don't know the right words to define the formatting I require and in the layout required, if this is possible.

Anyone able to help?

Thanks
Reply With Quote