• Msgbox doesn’t work (Excel 2000 VBA)

    Author
    Topic
    #358240

    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!

    Viewing 0 reply threads
    Author
    Replies
    • #534023

      It sounds to me like there is a macro someplace named MsgBox that is preempting Excel’s MsgBox. If it is happening in all workbooks, then I would look in any files that are in the XLStart folder and also any addins that are installed.

    Viewing 0 reply threads
    Reply To: Msgbox doesn’t work (Excel 2000 VBA)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: