View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Pranav Vaidya Pranav Vaidya is offline
external usenet poster
 
Posts: 180
Default DTPicker Default value

try using Now.Date
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"kj135" wrote:

I've created a macro in Excel 2003 and I'm using DTPicker for the user to
select the date and time. For some reason the date and time defaults to when
the macro was written. How do I tell it to default to Now?

I've tried "DTPicker1.Value = Now", but for some reason it does not work.

Thanks inadvance for your help.

Steve