How To Determine If A User Clicked The Cancel Button On VBA Input Box

In this post I am going to address the question:

“How can I determine if a user clicked the cancel button on a VBA Input Box”

I only need to check the length of the InputBox response. If the “Cancel” button was clicked,
the variable containing the value of the InputBox will be zero.

In the following code I am entering the name of the arguments which allows me to place the
arguments out of order:

Hope this helps. If you have any specific questions, contact me here.

Free! Subscribe To Our YouTube Channel!

facebooktwittergoogle_plusredditpinterestlinkedinmailby feather


Call Erik Now