Compile error with coding for date in textbox......2007 to 2010 issue!!!

Hello,

As the title explains I am having problems with a userform showing todays date. I had datepicker control originally on my userform but I could not get it to default to todays date when using the file on both 2007 & 2010. I then used a control called monthview which is not available on 2007. I decided that the easiest way would be to use a textbox on the userform with the following code:

Please Login or Register  to view this content.

This worked great on my 2007 version at home but to my amazement when I tried it on 2010 version at work I am getting the following error:

Compile Error:
Cant find project or library

If I change the first line to UserForm1 the macro runs but no date is in the textbox!!!!!

Can anyone help??

This is very annoying for such a simple operation.


Thanks,

Tony.

Capture1.PNG

Not sure what screenshots you want but I have attached one of the code error.

Thanks,

Tony.

Sorry to butt in - but there's most likely a missing reference in the Tools/References dialogue... Look for an entry starting 'MISSING:' and it is not necessarily related to the code that's throwing the error.

Hi sixthsense

Another screenshot attached showing what is highlighted. Capture2.PNG

Originally Posted by cytop

Sorry to butt in - but there's most likely a missing reference in the Tools/References dialogue... Look for an entry starting 'MISSING:' and it is not necessarily related to the code that's throwing the error.

Just unticked MISSING Microsoft Calendar control in the references & it seems to be working

Would this mean that this needs doing on every pc that this file is used on???

Thanks Cytop.

..Would this mean that this needs doing on every pc that this file is used on?

Depends on how you work. It there are 'local' copies of the file scattered all over the place - yes; but only for those machines running 2010. If you have a 'template' you distribute then edit that and then re-distribute.

Originally Posted by cytop

Depends on how you work. It there are 'local' copies of the file scattered all over the place - yes; but only for those machines running 2010. If you have a 'template' you distribute then edit that and then re-distribute.

The file has not been distributed yet so guess I will be ok.

Thanks guys

Tony.

Hi Tony,

See the following post which uses a custom 'date picker' written entirely in VBA.
http://www.excelforum.com/excel-gene...-combobox.html

Lewis