calendar build problem in XL2010, OK in XL2003

Using this code below to build a calendar userform, this works fine in 2003 but 2010 has a problem with this line:

Please Login or Register  to view this content.

and this line

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Originally Posted by trucker10

In Office 2010 is no mscal.ox

Ahhhhh, thanks for that lil tidbit.....off to D/L the ocx file

I can't get the computer to register the file for some reason....I didn't see an ocx file for 2010...the latest in that link was a 2003 version, so I D/L'd that one.

Originally Posted by jwright650

I can't get the computer to register the file for some reason....I didn't see an ocx file for 2010...the latest in that link was a 2003 version, so I D/L'd that one.

bumpity.

just wondering how to register the .ocx in Windows 7 for XL2010

I finally found the "Run" textbox after having to go into the menus in Windows 7 to turn it on, but I can't get it to register the .ocx file.

I thought that by using this calendar (code above) where it builds itself when you call the userform vs using a date picker like any of the add-ins(DTPicker, MS Calendar, MonthView, etc) that I would be able to use it on any version of Excel.

No, I haven't found a single solution that works on any platform. What works on one machine, doesn 't always work on another(at least for me.)

Guy, here is a file where you can export the Calendar Userform into something else if you want to try it.

I this one solved as well.....

Please Login or Register  to view this content.

I had to change every instance of "Date" and "Format" in this code to"

"VBA.Date" and "VBA.Format"

....then the code worked perfectly to build the calendar.