How to handle cancel when using the inputbox method
If you enter a zero and do OK it will be a Cancel.
I think using StrPtr is the only way.
RBS
"Rowan Drummond" wrote in message
...
Is this what you want?
Dim rslt As Variant
rslt = Application.InputBox("Enter Stuff")
If rslt = False Then
MsgBox "Cancelled"
Else
MsgBox rslt
End If
Hope this helps
Rowan
Lawood wrote:
How can I handle the return from a CANCEL button that is clicked on when
the inputbox method is present. As far as I can tell there is nothing
available to test on. The Inputbox Function is not an option. Thanks in
advance.
|