message box warning
 

I've got a macro that sends a certain page to print.
However, i want a message box to pop up and ask whether a particular
cell has been filled in. If the answer is yes, then it prints. If the
answer is no, then it cancels the process.

many thanks


--
M3Cobb
------------------------------------------------------------------------
M3Cobb's Profile: http://www.excelforum.com/member.php...o&userid=24986
View this thread: http://www.excelforum.com/showthread...hreadid=530742

message box warning
 

what part are you stuck on? the inputbox, the response or the printin
out

--
rocket061
-----------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...fo&userid=1949
View this thread: http://www.excelforum.com/showthread.php?threadid=53074

message box warning
 

This should be a start...

If MsgBox("Did you fill in cell whatever?", _
vbYesNo, "Ok To Print") = vbYes Then Call MyPrintMacro
--
HTH...

Jim Thomlinson


"M3Cobb" wrote:


I've got a macro that sends a certain page to print.
However, i want a message box to pop up and ask whether a particular
cell has been filled in. If the answer is yes, then it prints. If the
answer is no, then it cancels the process.

many thanks


--
M3Cobb
------------------------------------------------------------------------
M3Cobb's Profile: http://www.excelforum.com/member.php...o&userid=24986
View this thread: http://www.excelforum.com/showthread...hreadid=530742