View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default 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.