Hello all,

I'm coding the below with a text box in an userform.
The purpose is to display the date whenever the userform is opened.

My problem is, I have used this same code in Excel 2003, It was working fine,But now I'm using Excel 2010.
I get a compile error "Can't find project or library"

Dim x As Long
For x = 0 To 0
Me.txtDate = Format(Date + y, "Long date")
Next x

Please provide me an alternative

Thanks in advance