activesheet.oleobjects(1).object.value="10/10/2003"

Replace the 1 with whatever is the name of your dtp control

--

Regards,


Bill Lunney
www.billlunney.com

"Cathy Myers" wrote in message
...
Hi,

How do I set the default value for a date/time picker
using code. I am new to both Excel and VBA. Thanks.

C.M.