Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vbCancel
Greetings !
I have an InputBox. How do I distinguish between a valid input value of 2 and the user clicking on the "Cancel" button ? This worked just FINE - until I entered a value of 2 ! Ans = InputBox( _ "Enter a value between 1 and 5, myTitle, TP) If Ans = vbCancel Then Exit Sub TP = Ans |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXIT SUB UPON VBCANCEL | Excel Discussion (Misc queries) |