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
|