PDA

View Full Version : VBA Excel .OCX Control



murugavelmsc
04-11-2012, 09:38 PM
Hi All,

I have using excel VBA, in this am using the datepicker (.OCX) control (i.e mscal.ocx).

It working in windows XP and office 2003, 2007, 2010. But in windows 7 its not working. It throws an error while i am register the ocx control.

Please help me

Note:

Attached document is for your reference.

Thanks,
Murugavel

Bob Phillips
04-12-2012, 12:59 AM
Is your Windows 7 64 bit, the calendar doesn't work in 64 bit, you would need to craft your own control.

murugavelmsc
04-12-2012, 01:03 AM
HI,

I am using windows 7 32 Bit.

Thanks,
Murugavel S

Jan Karel Pieterse
04-12-2012, 01:38 AM
This is one of the reasons I steer away from third party controls.
If you Google for a bit you can find date-picking forms that are completely built using native Office forms controls.