Good evening I have another task I want to do. I have made a Macro that is a Caution MSGbox. What it does, once you press a button I want it to popup and you must click OK to continue or close it out and cease the operation.
Good evening I have another task I want to do. I have made a Macro that is a Caution MSGbox. What it does, once you press a button I want it to popup and you must click OK to continue or close it out and cease the operation.
What is your question? You have the macro and it works or doesn't work? I don't use macros, only VBA.
MsgBox can be used two ways.
1. Popup message, okay only, no optional responses by user. Syntax is:
MsgBox "This is my message.", "title"
2. Popup message, with optional responses. This is a function, must set a variable. Syntax is:
X = MsgBox("Select button.", select vb constants for button choices, "title")
VBA Help has more info on using MsgBox and InputBox.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.