Do
If Range("N57") = "" Then
Range("N57").Value = Inputbox("Please Enter a Value")
Else
'...
End If
Loop Until Range("N57").Value < ""

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"chalky" wrote in
message ...

Simple problem i know but i am hitting a blank with this one. I have a
macro that reads:

If Range("N57") = "" Then
Else

Before the Else i want a warning box in there instead ot the do nothing
that is currently in there. I just want it to read something like
"Please Enter a Value".

any takers?


--
chalky
------------------------------------------------------------------------
chalky's Profile:
http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=509435