View Single Post
 
Old 04-24-2020, 01:13 AM
kyotokisses kyotokisses is offline Windows 10 Office 2010
Novice
 
Join Date: Apr 2020
Posts: 11
kyotokisses is on a distinguished road
Default Modifying Next Paragraph Based on Dropdown Selected

Hi all, I'm relatively new to VBA and am trying to create a locked form which will look something like this.

1. [Topic] [Dropdown: (1) Applies; (2) Does not apply]

[Paragraph of text] - if Applies is selected, to retain existing formatting. If Does not apply is selected, to strikethrough whole paragraph.

Is there any macro which may be able to do this? Changes are not allowed in the contents in the paragraph and the document will be locked with other form field sections.

Thank you.
Reply With Quote