ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macro help... (https://www.excelbanter.com/excel-programming/315918-macro-help.html)

Dawn

macro help...
 
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[_6_]

macro help...
 
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?





All times are GMT +1. The time now is 09:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com