inputbox problem urgent

hello
here is a doubt
i want to differentiate between the ok and cancel button
on a inputbox
i want to know what button the user pressed.
how can i
i dont want the answer based on the string returned
as
if stringreturned <>"" then
cancel button pressed
else
ok button is pressed
end if

i want to know what button he pressed with out using the string
returned
please help me
quick

You know what button was pressed by the appropiate clicked event for the OK or Cancel button?
I don't understand your problem!

Are you on about MsgBox?

I don't think you can. You'll have to use the string. The problem with that is, that if nothing is entered in the textbox you can't know if the ok button or the cancel button was used, because both will return a zero length string.

VB Code:

Private Sub Command1_Click()
 
dim strInput$
strInput = InputBox("Enter a Year")
 
If StrPtr(strInput) = 0 Then
    ' You pressed cancel
Else
    'You pressed ok
End If
 
End Sub

hi nucleus
thank you
this code works