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