View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Cathy Myers Cathy Myers is offline
external usenet poster
 
Posts: 9
Default 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.



.