Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Picker | Excel Discussion (Misc queries) | |||
add date picker | New Users to Excel | |||
Cant set the date into a Date & Time Picker from Cell value | Excel Programming | |||
date picker | Excel Worksheet Functions | |||
date picker | Excel Programming |