Compile error hidden module

[Boss]

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

 

[Joel]

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]

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]

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]

Thanks Joel,

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

thansk!
Boss