Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Hiding forms with a timed event

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Montreal, Quebec
    Posts
    194
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am using the following to hide a userform after opening a workbook. It worked fine the first few times. Then I start getting an error message that the macro "KillTheForm" cannot be found. Any idea what the problem is?

    Application.OnTime Now + TimeValue("00:00:02"), "KillTheForm"

    Sub KillTheForm()
    frmMenu.Hide
    Call ListView
    frmMarginalCosts.Show
    End Sub

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Make sure that Sub KillTheForm() is in a Standard Module and not in a sheet, workbook, or userform Class module...
    Tom

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Montreal, Quebec
    Posts
    194
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    TsTom

    KillTheForm is in a module. I had been working OK for a while then all of a sudden I'm now getting the error message.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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