| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| warning message | Excel Discussion (Misc queries) | |||
| How to get rid of the warning message | Setting up and Configuration of Excel | |||
| Warning Message | Excel Worksheet Functions | |||
| warning message | Excel Discussion (Misc queries) | |||
| Pop up warning message! | Excel Programming | |||
![M3Cobb[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
