I am writing a simple macro and I am using the "input" fuction to gather some information from the user. So when someone clicks on the button attached to my macro an "InPut" box pups up and asks for the target value. That part works great but the problem is that if the user decided to click on the "cancel" button or hits "escape" an error message is generated. How Do I get arround this so that they user can stop running the macro by clicking on the "escape" button or hitting the "escapte" key. Thanks in advance.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Input boxes - how can I cancel out of it without generating an error message?
- Thread starter mkw4949
- Start date
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
Mike
Post your code.
Post your code.
Code:
Dim Ans As Variant
Ans = InputBox("Please enter a number")
If Not IsNumeric(Ans) Then
MsgBox "Hey, you crazy fool!!" & vbCrLf & "You've either not entered a number, pressed Cancel or hit the Esc key." & vbCrLf & "So this macro is over."
End
End If
Upvote
0
THank you! I have one question for ya though. I changed the variable type for the "ans" variable from Varient to Double and it didnt work. Do you know why that is? I dont really need to know since what you gave me works great but I was just wondering. Thanks again!
Upvote
0
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
Mike
I assume you got a 'Type Mismatch' error?
Well I think that's one of the VBA error message that isn't encrypted too much.
Basically if you hit Cancel or press Esc the inputbox returns an empty string "".
That's obviously incompatible with the Double data type.
If you really need a variable to be of a certain data type there are plenty of data conversion functions you could use. eg CDbl, Val etc
I assume you got a 'Type Mismatch' error?
Well I think that's one of the VBA error message that isn't encrypted too much.
Basically if you hit Cancel or press Esc the inputbox returns an empty string "".
That's obviously incompatible with the Double data type.
If you really need a variable to be of a certain data type there are plenty of data conversion functions you could use. eg CDbl, Val etc
Upvote
0
Similar threads
- Question
