A
Alan
How do I know the use click the cancel button on the input box ?
?
=?Windows-1252?Q?Jos=E9_Manuel_Ag=FCero?=
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" <[email protected]> escribió en el mensaje | How do I know the use click the cancel button on the input box ?
|
|
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" <[email protected]> escribió en el mensaje | How do I know the use click the cancel button on the input box ?
|
|
A
Alan
So 'nothing' is keyword ?
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
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
?
=?Windows-1252?Q?Jos=E9_Manuel_Ag=FCero?=
So 'nothing' is keyword ?
Yes, without the quotes.
Regards.
Yes, without the quotes.
Regards.
A
Armin Zingler
Alan said:
An empty string is returned:
dim s as string
s = inputbox(...)
if s.length = "" then
'cancel pressed or no input
else
'
end if
A
Alan
Thank you !
Armin Zingler said:
H
Herfried K. Wagner [MVP]
* José Manuel Agüero said:
The documentation says that it returns "" if it's cancelled.
?
=?iso-8859-1?Q?Jos=E9_Manuel_Ag=FCero?=
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" <[email protected]> escribió en el mensaje | > 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
|
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" <[email protected]> escribió en el mensaje | > 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
|
H
Herfried K. Wagner [MVP]
* José Manuel Agüero said: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...
;-)
A
Armin Zingler
José Manuel Agüero said: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*