removing message boxes

A

Aileen Hewat

I have created a macro for OnNotInList which includes my own messagebox.
However, the standard message box still appears after mine; how do I remove
it?
 
T

Tim Johnson

Aileen Hewat said:
I have created a macro for OnNotInList which includes my own messagebox.
However, the standard message box still appears after mine; how do I remove
it?
Click to expand...

Have you already tried the SetWarnings command?
 
F

fredg

I have created a macro for OnNotInList which includes my own messagebox.
However, the standard message box still appears after mine; how do I remove
it?
Click to expand...

Code is easier.
Use:
Response = acDataErrContinue

If MsgBox("Your message here.",vbYesNo) = vbNo Then
Response = acDataErrContinue
End If
 
A

Aileen Hewat

Tim, I worked it out and used it but it had no effect - perhaps because it is
an error message - "The text is not in the list. Choose from the list"?
 
T

Tim Johnson

Aileen, sorry that the SetWarnings didn't work.

In this case, and after testing a little myself, I'm going to have to agree
with Fred on this one.
 
Top