Hi,

This code looks fine to me...


Private Sub Calendar1_Click()



dformat = format(Calendar1.Value, "dd-mmm-yyyy")

TextBox1.Value = dformat
End Sub



BUt ut give me a compile error. Can't find project in library.

Please hepl..

Thanks!
Boss

In VBA window go to Tools - References and make sure Calendar Control is
checked. When you click on the line Calendar control a path name for the
library objectt will appear. Make sure the library file is on the PC.

"Boss" wrote:

Hi,

This code looks fine to me...


Private Sub Calendar1_Click()



dformat = format(Calendar1.Value, "dd-mmm-yyyy")

TextBox1.Value = dformat
End Sub



BUt ut give me a compile error. Can't find project in library.

Please hepl..

Thanks!
Boss

Thanksyou so much...

Actually ref edit is missing.
I tried copying from other system buy didn't helped..

what should i do now.

Thanks!
Boss

"Joel" wrote:

In VBA window go to Tools - References and make sure Calendar Control is
checked. When you click on the line Calendar control a path name for the
library objectt will appear. Make sure the library file is on the PC.

"Boss" wrote:

Hi,

This code looks fine to me...


Private Sub Calendar1_Click()



dformat = format(Calendar1.Value, "dd-mmm-yyyy")

TextBox1.Value = dformat
End Sub



BUt ut give me a compile error. Can't find project in library.

Please hepl..

Thanks!
Boss

Same thing for RefEdit. Look for "Ref Edit Control" in references. Somebody
last week had the same problem and never found out what was wrong. I thinik
they had more than one version of excel loaded on their PC. They had an
Office11 and Office12 directory on their PC.

I think I had this problem the 1st time I used RefEdit on my PC a few years
ago. Don't remember what the solution was. There may of been something
missing in the System32 windows directory. or I had to add an update to my PC.

"Boss" wrote:

Thanksyou so much...

Actually ref edit is missing.
I tried copying from other system buy didn't helped..

what should i do now.

Thanks!
Boss

"Joel" wrote:

In VBA window go to Tools - References and make sure Calendar Control is
checked. When you click on the line Calendar control a path name for the
library objectt will appear. Make sure the library file is on the PC.

"Boss" wrote:

Hi,

This code looks fine to me...


Private Sub Calendar1_Click()



dformat = format(Calendar1.Value, "dd-mmm-yyyy")

TextBox1.Value = dformat
End Sub



BUt ut give me a compile error. Can't find project in library.

Please hepl..

Thanks!
Boss

Thanks Joel,

The refedit file was there in the system.
All was rquired was "browse"

thansk!
Boss

"Joel" wrote:

Same thing for RefEdit. Look for "Ref Edit Control" in references. Somebody
last week had the same problem and never found out what was wrong. I thinik
they had more than one version of excel loaded on their PC. They had an
Office11 and Office12 directory on their PC.

I think I had this problem the 1st time I used RefEdit on my PC a few years
ago. Don't remember what the solution was. There may of been something
missing in the System32 windows directory. or I had to add an update to my PC.

"Boss" wrote:

Thanksyou so much...

Actually ref edit is missing.
I tried copying from other system buy didn't helped..

what should i do now.

Thanks!
Boss

"Joel" wrote:

In VBA window go to Tools - References and make sure Calendar Control is
checked. When you click on the line Calendar control a path name for the
library objectt will appear. Make sure the library file is on the PC.

"Boss" wrote:

Hi,

This code looks fine to me...


Private Sub Calendar1_Click()



dformat = format(Calendar1.Value, "dd-mmm-yyyy")

TextBox1.Value = dformat
End Sub



BUt ut give me a compile error. Can't find project in library.

Please hepl..

Thanks!
Boss