Date Picker component
 

Hi,

Could someone help me with this issue?

I am developing a VBA Macro and I add a date picker component on the sheet.

But when I test this file on another computer this date picker disappear.

What's the best way to link this component to the sheet and every time I
send this file for other people it works fine???

Thanks a lot.

Anelisa

Date Picker component
 

The Date Picker is part of the mscomct2.ocx file

this is found in your windows\system folder

If the computer you are sending the file to doesn't have this active x file
then they wont be able to use the date picker

This file needs to be copied to there system folder

Then a reboot is required

http://www.apofficesolutions.com

--
Anthony Prescott
http://www.apofficesolutions.co.uk

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200903/1

Date Picker component
 

Maybe you're using the calendar that only works when Access is installed? And
you have Access, but the recipients don't????

Maybe you can use a free replacement.

Ron de Bruin has some notes:
http://www.rondebruin.nl/calendar.htm

Anelisa Gomes wrote:

Hi,

Could someone help me with this issue?

I am developing a VBA Macro and I add a date picker component on the sheet.

But when I test this file on another computer this date picker disappear.

What's the best way to link this component to the sheet and every time I
send this file for other people it works fine???

Thanks a lot.

Anelisa

--

Dave Peterson