Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2001
    Location
    SF, CA
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Msgbox doesn't work (Excel 2000 VBA)

    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!

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Msgbox doesn't work (Excel 2000 VBA)

    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.
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    Jul 2001
    Location
    SF, CA
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Msgbox doesn't work (Excel 2000 VBA)

    that was easy, thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •