Consulting

Results 1 to 3 of 3

Thread: Solved: VBA Run-time-error '424'

  1. #1
    VBAX Mentor
    Joined
    Jan 2008
    Posts
    384
    Location

    Solved: VBA Run-time-error '424'

    I have an Excel Userform that was working but suddenly I'm getting a
    Run-time-error '424'

    This is what is somehow causing the error

    [VBA]
    Sub MonthlyExpense()
    DForm.Show
    End Sub
    [/VBA]

    Any ideas what could be causing this?

  2. #2
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    It is not that code (unless that is not the form name) - the error is most likely in the Initialize or Activate event of the userform. You may press f8 to step into that.
    Be as you wish to seem

  3. #3
    VBAX Mentor
    Joined
    Jan 2008
    Posts
    384
    Location
    Thanks Afatoon:

    The problem was in the Initialize event. A typo.

Posting Permissions

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