View Single Post
 
Old 02-10-2024, 11:13 AM
viewtost viewtost is offline Windows 10 Office 2019
Advanced Beginner
 
Join Date: Jul 2021
Posts: 35
viewtost is on a distinguished road
Default Ensure that a form has been completed

Hello all,

I hope you are well.

I have a form with three different lines:

Name: It´s a rich text content control
Surname: It´s a rich text content control
Start date: It´s a date picker content control

I would like to write a macro that checks if all the fields of the form (name, surname, and start date) have been filled. If they have been filled in, I want a message to pop up saying “Ready to be printed”; if any of the fields have not been completed, I want a message to pop up saying “Please complete all the fields”.

Then, when people fill in the form, they can run the macro to ensure they haven't missed any fields before printing it out. The form will contain more fields in the future, so I would like a macro that could work with any new fields that I may add to the form.

For better understanding, I am attaching an example of the form

Thanks!
Attached Files
File Type: docm Example of form.docm (18.8 KB, 3 views)
Reply With Quote