If msgbox("Your Text") = VbCancel then
msgbox("You must enter some data"),VbOkOnly
else
end if
--
Best wishes,

Jim


"CatherineN" wrote:


I am trying to put an input box in that wont let you just push cancel,
somethign MUST be input. Right now when they push cancle it just has
an error in the program, but this needs to be a little more user
friendly. Can i do this by having a message box pop up saying you must
enter something then close that and have the inputbox still be up, or
have a new input box come up that says you must enter a value and have
it loop until a value is input. I have no idea how to do this though,
please help.


--
CatherineN
------------------------------------------------------------------------
CatherineN's Profile: http://www.excelforum.com/member.php...o&userid=35469
View this thread: http://www.excelforum.com/showthread...hreadid=560737