vbCancel
You're right.
I was using the InputBox method (Application.InputBox) rather than
the InputBox function. I should have read the OP's question and your
response in a less cursory manner.
Paul
-----------------------------------------------------------------------
On Thu, 23 Oct 2003 15:09:17 -0400, "Tom Ogilvy"
wrote:
But he was making his comparison to vbCancel which is a two and is usable
with a msgbox, not an input box.
? vbCancel
2
You said hitting cancel in an inputbox returns zero - it doesn't
"When I hit Cancel (or X) on an InputBox, I get the returned value of 0
(Zero)."
Tested in the immediate window (cancel was selected)
? inputbox("abc")
------ it returned a null string
? typename(inputbox("abc"))
String
A vba inputbox always returns a string.
An empty string is coerced to zero in most cases if you force it to be used
as a number, but not always. For instance
? inputbox("abc") = 0
raises a type mismatch error when I hit cancel.
I just provided information on what an inputbox actually returns.
|