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
|