Cancel Button Code for an Input Box 1

[JRA]

Hello ...

I'm using an Input Box and I want to write some sort of code that will direct the user to a specific MsgBox if the user clicks on 'cancel'. Currently, when the user clicks on 'cancel', it continues as it would if they had clicked on ok and then later the error message (that I created) pops-up and says used error.

Thanks,
James.

 

[kathryn]

According to the help file "If the user clicks Cancel, the function returns a zero-length string ("&quot." Why don't you test to see if the value is "", and if so, show the msgbox:

strReturn = InputBox(.....)

if strReturn = "" then
msgbox "...."
End if Kathryn