When using an inputbox, how do you keep it from generating an error i
the user clicks cancel? I want them to be able to cancel it, just no
have to think about whether they should end or debug.

So far I've had no luck with things such as

.....
if VBcancel then end
elseif
.....

because that cuts my program short. What is the trick

--
wilro8
-----------------------------------------------------------------------
wilro85's Profile: http://www.excelforum.com/member.php...fo&userid=2693
View this thread: http://www.excelforum.com/showthread.php?threadid=46605