Surely, you would have an OK button on the form, and when that is pressed
check the data for completeness. If not complete, don't start the macro and
ask for more.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dawn" wrote in message
...
I am currently using a userform that will enter data into an excel report
and
start a macro.

Is there a code I could write to stop the macro from running and to prompt
the user if all of the required information is not complete?