Msg Box

[newo]

Hi all, I am having difficulty with my VBA to create a message box to tell when the macro (Job) has been done I used this but to no avail.

MsgBox "Record Submission complete", vbOKCANCEL

Just doesn't work

could someone enlighten me please

Thanks

n

[mikerickson]

I think the syntax you are looking for is

Please Login or Register  to view this content.

[dominicb]

Hi newo

This code will work just fine to display a message box onscreen. What is the problem with it? What are you expecting to get?

DominicB

[newo]

Thanks for your quick replies I missed out the brackets so it works now

Thanks

N