I call a userform and need to determine whether the user clicked "OK" or "Cancel" on the form. Is there a way to do this without setting a global variable and checking it after the form is closed?
I want to say something like:
where "run" is a method in userForm1 that returns a different value for OK and Cancel. But I don't know how to make this happen.![]()
myInt = userForm1.run
Thanks Andy!
Bookmarks