This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Dearest Wizards,
Maybe an odd question but,
Working on a big project, thousands of lines of VBA code. Having the usual trouble with crashes and 'trying' to resolve them with MsgBox diagnostics. Strange thing going on though. When I try to use MsgBox something is happening (compiler?) that it changes the text to msgbox (lower case) and gives an error message:
Compile error:
Wrong number of arguments or invalid property assignment
Interestingly, prior saves of the file from months ago don't give me this problem/error; the MsgBox function works great. Is this an update issue? Anyone else having the same problem?
TIA,
Sam
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Have you created a procedure (sub) or function named msgbox, perhaps? Search your code for all uses of msgbox.
Also, make sure that you haven't given a module or userform the name msgbox.
Hans,
You were spot on! I had done exactly as you had suspected. All is working much better now; thank you for the help!!
Sam