• 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: Reply #534023 in 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:




    Cancel