Message Box Troubles

[Yeoman.jeremy]

Hi there.
I Tried creating a message box using vba, and nothing is working.
I've looked through all the guide sites and nothing is working for me.

I'm writing

Sub MsgBox_mcr()
MsgBox "Test is complete."
End Sub

for example, and when i run the macro
it says

"Compile Error,
Wrong number of arguements or invalid property assignment."

 

[Tom Urtis]

Something is going on other than that macro because it runs fine for me. Maybe you have other code you are not posting, including exactly how you call that macro. Try posting all your code and / or explaining exactly what it is you are doing. The answer lies beyond what you've provided.

 

[Yeoman.jeremy]

Sub CustomerFeedbackMsgBox()
MsgBox "You have not recorded how the customer heard of this store. Please do so before completing this form."
End Sub

This is it.

I want to run this macro from another macro, but before i can even do that it has to work.

Whenever i try to step through this, or click the play button in my vb editor it comes up with the error message as above

 

[Tom Urtis]

That second macro works OK too. Maybe you have a stray character or line of code elsewhere in a module.

 

[Sektor]

Did you press Enter after "Please do so"?

 

[Ruddles]

Have you got a procedure called MsgBox that you wrote yourself? Perhaps the procedure that's calling CustomerFeedbackMsgBox?

 

[Yeoman.jeremy]

I looked back through my other modules, and discovered a couple of unfinished MsgBox modules lying around

Just got rid of those and it works fine now.
Interesting.

Thanks all

 

[Ruddles]

Very unwise to give modules the same name as existing VBA functions. It confuses the hell out of VBA!