Hi vandaley

There are always problems when you want to send the Date/time controls to
other users.
(Not alll machines have this controls)
http://www.rondebruin.nl/calendar.htm

Best to do is to use 3 comboboxes (Y,M,D)
This is always working and you can use the Isdate function to test if it is a correct Date


--
Regards Ron de Bruin
http://www.rondebruin.nl



"vandaley" wrote in message oups.com...
Hi,

I want to use the microsoft date and time picker control in my VBA for
Excel.

I understand there are issues with this control?

Will all the clients be able to see this control when running the user
form?

Is there another control of the same nature i can use?

Thanks,