Can I use a check box, that when selected, auto fills text box further down the form with a preset statment?

Ray 21 Reputation points
2022-11-18T17:00:01.7+00:00

I need a way to reduce human error in completing my form. Currently I have 44 options (check boxes) that when selected should be accompanied with a statement base on that selection.
Right now, people can select a number of options (check boxes) then complete accompanying statements for different options. I'm then left having to scroll through and compare the two tables and find where the mistake is.

I need text box or table that will appear and prompt the user into completing the statement based on the option they have selected. Any ideas or solutions will be greatly appreciated.

Thank you, Ray,

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Word | For business | Windows
0 comments No comments
{count} votes

Accepted answer
  1. John Korchok 6,306 Reputation points Volunteer Moderator
    2022-11-18T18:40:55.89+00:00

    Yes, what you want is possible.

    There are 4 types of check box: Userform (on a VBA userform), Legacy Formfield, ActiveX and Content Control. The latter 3 appear directly on the Word page. The steps to implement your request depend on what type of check box you're using.


1 additional answer

Sort by: Most helpful
  1. Oskar Shon 866 Reputation points
    2022-11-18T17:56:17.693+00:00

    You can, use VBA to automatize your file, and follow your readers step by step with highlight incorrect places or shutdown color from empty spaces.
    Also you can have connection between fields based on comboboxes or listviews. I don't know what your experience is on this topic.
    If you start then start from a book with VBA chapter. That is a good way to understand how that works.

    That you should to know that files with code you should "save with code". That is not trivial because you can lost your efforts.
    And our readers Should to know who is a creator, because file with code can be block because security issue.

    If you start and you have a problem with a specific case, show what exactly.

    Regards.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.