How to detect the input box is cancelled

[Alan]

How do I know the use click the cancel button on the input box ?

[José Manuel Agüero]

Hello, Alan:

InputBox returns 'Nothing' if the Cancel button is pressed:

dim a as string
a=inputbox("Write something or press Cancel")
if a is nothing then
msgbox("The user pressed Cancel.")
else
'Do something with a.
end if
Regards.
"Alan" <NO**************@yahoo.com.au> escribió en el mensaje news:%2****************@tk2msftngp13.phx.gbl...
| How do I know the use click the cancel button on the input box ?
|
|

[Alan]

So 'nothing' is keyword ?

"Jos?Manuel Agüero" <jmªgue®ø@v°daƒøne.e?> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
Hello, Alan:

InputBox returns 'Nothing' if the Cancel button is pressed:

dim a as string
a=inputbox("Write something or press Cancel")
if a is nothing then
msgbox("The user pressed Cancel.")
else
'Do something with a.
end if

[José Manuel Agüero]

> So 'nothing' is keyword ?

Yes, without the quotes.

Regards.

[Armin Zingler]

"Alan" <NO**************@yahoo.com.au> schrieb

How do I know the use click the cancel button on the input box ?

An empty string is returned:

dim s as string
s = inputbox(...)
if s.length = "" then
'cancel pressed or no input
else
'
end if
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Alan]

Thank you !

"Armin Zingler" <az*******@freenet.de> wrote in message
news:eZ**************@TK2MSFTNGP12.phx.gbl...

"Alan" <NO**************@yahoo.com.au> schrieb

How do I know the use click the cancel button on the input box ?

An empty string is returned:

dim s as string
s = inputbox(...)
if s.length = "" then
'cancel pressed or no input
else
'
end if
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Herfried K. Wagner [MVP]]

* José Manuel Agüero <jmªgue®ø@v°daƒøne.e§> scripsit:

InputBox returns 'Nothing' if the Cancel button is pressed:

dim a as string
a=inputbox("Write something or press Cancel")
if a is nothing then
msgbox("The user pressed Cancel.")
else
'Do something with a.
end if

The documentation says that it returns "" if it's cancelled.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[José Manuel Agüero]

OK, I mistaked the function. InputBox returns "" if cancelled, but...
String.Length is an Integer, you should write:

If s="" Then

Or

If s.length=0 Then

Regards... and sorry for my mistake :(
"Armin Zingler" <az*******@freenet.de> escribió en el mensaje news:eZ**************@TK2MSFTNGP12.phx.gbl...
| "Alan" <NO**************@yahoo.com.au> schrieb
| > How do I know the use click the cancel button on the input box ?
|
| An empty string is returned:
|
| dim s as string
| s = inputbox(...)
| if s.length = "" then
| 'cancel pressed or no input
| else
| '
| end if
|
|
| --
| Armin
|
| http://www.plig.net/nnq/nquote.html
| http://www.netmeister.org/news/learn2quote.html
|

[Herfried K. Wagner [MVP]]

* José Manuel Agüero <jmªgue®ø@v°daƒøne.e§> scripsit:

OK, I mistaked the function. InputBox returns "" if cancelled, but...
String.Length is an Integer, you should write:

If s="" Then

Or

If s.length=0 Then
ACK.
Regards... and sorry for my mistake :(

No problem...

;-)

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Armin Zingler]

"José Manuel Agüero" <jmªgue®ø@v°daføne.e§> schrieb

OK, I mistaked the function. InputBox returns "" if cancelled,
but... String.Length is an Integer, you should write:

If s="" Then

Or

If s.length=0 Then

Regards... and sorry for my mistake :(

And sorry for _my_ mistake. :-(( *argh* *gnrrrr*
--
Armin