macro help...

[Guest]

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?

 

[Bob Phillips]

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)