How To Create Form In Excel Template Userform Using Vba

In paper forms the specific sub-questions cannot be hidden from the user when they are not relevant to them - but in interactive forms this is relatively easy to do. Use progressive revealing as much as possible in your form design to shield your users from questions they do not need to see.

Provide checklists. As users complete your form, you may well be asking them to provide supporting information or attach supplementary documents where required. Providing a checklist, often at the beginning or end of a form, helps remind users about all the things they should remember to attach, and any further steps they need to go through.