Problem With Date and Time Picker Control 6.0

Hi All,

I hope you can help. I am developing a Add-in in Excel 97 (So this addin
will work in version of 97 and onwards). The problem was I needed a date
picker like the one was available in Excel 2000.

I looked on MSDN and downloaded the MSCOMCT2.OCX & MSCOMCT2.INF file. This
file was registered using Regsvr32, which was successful as it also created a
MSCOMCT2.SRG file.

However when I attemp to use the DTPicker I get the following message in
msgbox:

"The control could not be created because it is not properly licensed"

Any help will be greatly appreciatated.

Many Thanks

I would assume you need Microsoft Developers Toolkit or VB6 on your machine
to implement these files.

Mike F
"Sunnous" <[email protected]> wrote in message
news:[email protected]...
> Hi All,
>
> I hope you can help. I am developing a Add-in in Excel 97 (So this addin
> will work in version of 97 and onwards). The problem was I needed a date
> picker like the one was available in Excel 2000.
>
> I looked on MSDN and downloaded the MSCOMCT2.OCX & MSCOMCT2.INF file.
> This
> file was registered using Regsvr32, which was successful as it also
> created a
> MSCOMCT2.SRG file.
>
> However when I attemp to use the DTPicker I get the following message in
> msgbox:
>
> "The control could not be created because it is not properly licensed"
>
> Any help will be greatly appreciatated.
>
> Many Thanks

Just what it means. You don't have a license to use that control in design
mode and Excel VBA runs in design mode (unlike a VB6 compiled app).

Perhaps the calendar control is a reasonable alternative:

http://www.rondebruin.nl/calendar.htm

--
Regards,
Tom Ogilvy


"Sunnous" <[email protected]> wrote in message
news:[email protected]...
> Hi All,
>
> I hope you can help. I am developing a Add-in in Excel 97 (So this addin
> will work in version of 97 and onwards). The problem was I needed a date
> picker like the one was available in Excel 2000.
>
> I looked on MSDN and downloaded the MSCOMCT2.OCX & MSCOMCT2.INF file.
This
> file was registered using Regsvr32, which was successful as it also
created a
> MSCOMCT2.SRG file.
>
> However when I attemp to use the DTPicker I get the following message in
> msgbox:
>
> "The control could not be created because it is not properly licensed"
>
> Any help will be greatly appreciatated.
>
> Many Thanks