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" <[email protected]> wrote in message
news:[email protected]...
> 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.

I have just been reading up on StrPtr following your post - it's a new
one for me. Thanks.

Regards
Rowan

RB Smissaert wrote:
> If you enter a zero and do OK it will be a Cancel.
> I think using StrPtr is the only way.
>
> RBS
>
> "Rowan Drummond" <[email protected]> wrote in message
> news:[email protected]...
>
>> 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.
>
>