I have the Inputbox as a search, and I have it protected so that if you accidentally don't type any text an click ok a msgbox pops up and it allows you to try again. However if someone clicks on the search accidentally cancel won't work to exit the sub. so basically right now you must enter some sort of text to get out of the inputbox. I tried cancelerror = true and then an error handler to exit the sub, but no luck... any other suggestions??
thanks,
Josh