Posted to microsoft.public.excel.programming
|
|
Set Value for Date/Time Picker
Thanks.
C.M.
-----Original Message-----
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.
.
|