+ Reply to Thread
Results 1 to 3 of 3

Simple Calendar pop up macro --> error Run-time error '424': Object required

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    36

    Simple Calendar pop up macro --> error Run-time error '424': Object required

    Hi there, I am attempting to get a "pop-up" Calendar to display however I am getting an error!

    I am a little puzzled as to why, here is what I have:
    One Workbook with five sheets, one form "frmCalendar, and one Module "Open_Calendar".

    On sheet1 I select a cell and run the macro "Open_Calendar" result is: error Run-time error '424': Object required.

    Form frmCalendar Code:
    Please Login or Register  to view this content.
    Module Open_Calendar Code:
    Please Login or Register  to view this content.
    Thanks for taking the time to read!

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Simple Calendar pop up macro --> error Run-time error '424': Object required

    Did you copy & paste? If so you have a typo here that is causing your problem:

    Please Login or Register  to view this content.
    I suggest you go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:
    Please Login or Register  to view this content.
    This option requires all variables to be declared. If you had it here, you would have gotten a compile error on that line that says "Compile error: Variable not defined." Typos in variable names cause endless mischief.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    06-04-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    36

    Re: Simple Calendar pop up macro --> error Run-time error '424': Object required

    Works fine after fixing the typo. Thanks for the tip about "Require Variable Declaration." much appreciated!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Run-Time Error Object Required
    By Trevasaurus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2013, 01:20 PM
  2. [SOLVED] Simple object required error in loop
    By Dunctonsteel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2013, 01:16 PM
  3. Run Time Error 424:Object Required
    By ewalton87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2011, 09:33 PM
  4. Getting Run Time Error 424 object required
    By arvin in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-11-2010, 01:36 PM
  5. Excel 2007 Beta 2 - Macro Run-time error '424' Object required
    By jcm21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2006, 02:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1