Return values from UserForms

[Guest]

I open an input form when the sheet is opened.
How can I get a return value from a UserForm, so I can close the form and
cancel the action if the Cancel Button is pressed, and I return to the
spreadsheet, as opposed to accepting the input, printing it, saving it and
closing it if they press OK.

TIA

 

[Tom Ogilvy]

You don't.

Put a public variable in the general module, and have the cancel button set
the value of that variable so you can check it in your code.

 

[Guest]

Thanks Tom

You don't.

Put a public variable in the general module, and have the cancel button set
the value of that variable so you can check it in your code.