How do I capture CANCEL on an Inputbox?

's Computer Specifications

Excel 2002 SP3
Windows XP Pro SP2

I can do it on a MsgBox, but can't figure it out on an InputBox. Anyone?

-gk-

's Computer Specifications

Check to see if the string returned is "".

dim myStr as string
mystr = inputbox("hi")
if mystr = "" then
'user hit cancel
exit sub
end if

Toxicdistortion wrote:
>
> Excel 2002 SP3
> Windows XP Pro SP2
>
> I can do it on a MsgBox, but can't figure it out on an InputBox. Anyone?
>
> -gk-

--

Dave Peterson

's Computer Specifications

Doh!

Thank you!

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Check to see if the string returned is "".
>
> dim myStr as string
> mystr = inputbox("hi")
> if mystr = "" then
> 'user hit cancel
> exit sub
> end if
>
>
> Toxicdistortion wrote:
>>
>> Excel 2002 SP3
>> Windows XP Pro SP2
>>
>> I can do it on a MsgBox, but can't figure it out on an InputBox. Anyone?
>>
>> -gk-
>
> --
>
> Dave Peterson

's Computer Specifications

Doh!

Thank you!

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Check to see if the string returned is "".
>
> dim myStr as string
> mystr = inputbox("hi")
> if mystr = "" then
> 'user hit cancel
> exit sub
> end if
>
>
> Toxicdistortion wrote:
>>
>> Excel 2002 SP3
>> Windows XP Pro SP2
>>
>> I can do it on a MsgBox, but can't figure it out on an InputBox. Anyone?
>>
>> -gk-
>
> --
>
> Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I capture CANCEL on an Inputbox?	Toxicdistortion	Microsoft Excel Programming	0	27th Oct 2006 12:37 AM
Cancel an InputBox?	=?Utf-8?B?Q2hyaXMgQnVybmV0dGU=?=	Microsoft Access	4	4th Dec 2005 08:14 PM
Cancel an InputBox?	=?Utf-8?B?Q2hyaXMgQnVybmV0dGU=?=	Microsoft Access Form Coding	4	4th Dec 2005 08:14 PM
InputBox Cancel	Joe Delphi	Microsoft Access	1	9th Oct 2005 04:38 AM
InputBox Cancel	Bob	Microsoft VB .NET	3	9th Nov 2003 07:45 PM