+ Reply to Thread
Results 1 to 7 of 7

Run-time error '424' Object required. Important.

  1. #1
    Registered User
    Join Date
    02-11-2012
    Location
    Poland
    MS-Off Ver
    EXCEL 2007
    Posts
    3

    Run-time error '424' Object required. Important.

    It's weird. I've had written an invoice application in excel ( using macro and VBA ) about 8 years ago. So far, it was great. ( I didn't have to improve anything in 8 yeras !! ) ... but... recently I've done format on my computer ( it wasn't first time of coure ) but after that i found problems in my app.

    I have button on whick i click and i'm getting today's date.

    This is function :

    Private Sub CommandButton3_Click()
    Calendar1.Today
    Calendar1.Visible = False
    i1 = 1
    End Sub

    Everytime i click on it, i get a message "Run-time error '424' Object required." Ale tthe line " Calendar1.Today" is seleceted. No idea what to do. Tried to reinstall Office ( i'm using 2007 ).

    I want to emphasize that for 8 years everything worked fine, and nothing in the code has changed. Error jumped out just like that.

    Please help me.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Run-time error '424' Object required. Important.

    Hi Umix,

    Welcome to the forum.

    Just as an option, check below two points:-

    1) do you have the calendar by the name "Calendar1"?
    2) may be you need to enable the calendar control in Tools -> References.


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    02-11-2012
    Location
    Poland
    MS-Off Ver
    EXCEL 2007
    Posts
    3

    Re: Run-time error '424' Object required. Important.

    answer to 2) yes, i had done this before

    answer to 1) yes, i have

    problem still occurs

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    13,913

    Re: Run-time error '424' Object required. Important.

    Hi umix and welcome to the forum,

    The Calendar Control has changed many times in Excel and Access. I don't believe it is still distributed with the product. The current control is called DTPicker (Date Time Picker).
    See some articles like: http://www.fontstuff.com/vba/vbatut07.htm

    Look at VBA -> Tools -> References to see if any of them are "MISSING" and uncheck the box to see if that helps.
    One test is worth a thousand opinions.
    Click the * below to say thanks.

  5. #5
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,590

    Re: Run-time error '424' Object required. Important.

    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  6. #6
    Registered User
    Join Date
    02-11-2012
    Location
    Poland
    MS-Off Ver
    EXCEL 2007
    Posts
    3

    Re: Run-time error '424' Object required. Important.

    Thank you guys, appreciate that. Check it in a minute.

  7. #7
    Registered User
    Join Date
    02-14-2012
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    1

    Re: Run-time error '424' Object required. Important.

    hier an Alternative to Calendar Control.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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