Ask a new question

Using controls and conditional formatting

This would be for Word 2010. I have a two-page letter that has one paragraph that changes per subject category and action.  I have four categories with checkboxes. I have four actions with checkboxes. Depending on which box is checked for the category and then which is checked for the action would determine the paragraph that would pop up in the letter.

 

Any idea how this can be done?

 

Thanks!

What kind of controls?

 

You would basically create building block entries for each possible combination of cat/action and then after the user selects the cat/action insert the appropriate buildingblock.

 

You could do this via userform or the exit event from the document controls.

 

It is going to take some VBA code, so if you don't know how or want to learn then you might have to hire it out.

 

The gist:

 

Select Case "Cat"

   Case 1

      Select Case "Action"

         Case 1

            'Do this

         Case 2

            'Do that

         Case 3

 

         Case 4

 

     End Select

   Case 2

 

   Case 3

 

   Case 4

 

End Select

Greg Maxey
***
Death smiles at us all, but all a man can do is smile back.


For more help with Word visit:
http://gregmaxey.com/word_tips.html

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

See the examples at:

http://www.msofficeforums.com/word-vba/16505-change-color-according-dropdown-selection.html#post47254 (conditional formatting)

http://www.msofficeforums.com/word-vba/15098-how-do-i-insert-autotext-using-contol.html#post42172 (conditional content insertion)

http://www.msofficeforums.com/word/16613-import-exclusion-list-quote.html (conditional content deletion)

Cheers
Paul Edstein
(Fmr MS MVP - Word)

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated September 30, 2021 Views 59 Applies to: