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

**umix** · 02-11-2012, 10:15 AM

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.

**dilipandey** · 02-11-2012, 10:29 AM

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>

**umix** · 02-11-2012, 07:46 PM

answer to 2) yes, i had done this before

answer to 1) yes, i have

problem still occurs

**MarvinP** · 02-11-2012, 09:43 PM

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.