The input box is a great way to retrieve and process input from your user. In the following example we’ll control program flow based on the user’s input in the inputbox. Your user will enter a text value and we will evaluate their answer and send them in the right direction. Sub InputboxVBA() Dim strAnswer […]

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 […]