How to put a message box & have the user not close it?

  • Thread starter Thread starter Juan
  • Start date Start date
J

Juan

Is it possible to put a message box out for say at the
beginning of a sub and then have it be close by the end of
the sub? But I don't want the user to be able to close
the message box. I want the message box to be told with
code to close when it is about to get out the sub. I am
coding in VBA.

Thanks
 
Is it possible to put a message box out for say at the
beginning of a sub and then have it be close by the end of
the sub?
Click to expand...

Not directly with the built-in MsgBox function. You'll have to create your
own form to represent the Message Box; open the form at the start of the
proc, and close it with Docmd.Close acForm call in error handling code and
at the end of the proc.

-- Dev
 
Back
Top