View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach[_6_] Otto Moehrbach[_6_] is offline
external usenet poster
 
Posts: 201
Default InputBox Function & Cancel

Thanks Norman. I'll check it out in the morning. Thanks for your help.
Otto
"Norman Jones" wrote in message
...
Hi Otto,

You can use the StrPtr function:

Sub Tester()
Dim strInput As String

strInput = InputBox("Complete this quotation", _
"InputBox Demo", _
"Friends, Romans and Countrymen")
If StrPtr(strInput) = 0 Then
MsgBox "You pressed Cancel"
Else
If Len(strInput) = 0 Then
MsgBox "OK was pressed but no entry was made."
Else
MsgBox "Your entry was: " & strInput
End If
End If
End Sub

For information about StrPtr see Karl Peterson's site:

http://www.mvps.org/vb/index2.html?tips/varptr.htm


---
Regards,
Norman



"Otto Moehrbach" wrote in message
...
Excel 2002, WinXP
I am using the InputBox Function to get some info from the user.
I want to trap the instance of the user clicking the Cancel button.
Clicking on the Cancel button returns a zero-length string.
No input and clicking on the OK button also returns a zero-length string.
Is there a way to differentiate between the two actions?

I realize that I can use the InputBox Method and specify a type and
thereby force the user to input something. Also the Cancel button
returns a False.
Thanks for your help. Otto