InputBox question

[vzachin]

hi,

i have an inputbox where the OP enters either a Y or N or blank and then can CLICK OK.
If the OP clicks CANCEL, i want to exit the sub.
How do i code that? i've done this before but i can't find my notes. :-(

InPutDte = ""
InPutDte = inputbox$("Y or N")
InPutDte = ucase$(Create)
if InPutDte = "" or InPutDte = "N" then
exit sub : end if

thanks
zach

 

[vzachin]

never mind...was a dumb question

thanks