Hi,
For some reason, when I create a message box for my macros in VBA, I get the following error:
Compile error:
Wrong number of arguments or invalid property assignment.
This happens even when I type up a “test” message like this in the Immediate Window:
msgbox(“message”)
In fact, I noticed the autofill doesn’t pop-up like it normally does after typing msgbox_. I recently started declaring variables for my macros, so is this related?
This error has only been popping up in the last 2 days when I received a new computer. Otherwise, my message boxes worked fine a few days ago and on Excel 97.
Any ideas?
thanks for you help!