Posted to microsoft.public.excel.programming
|
|
Setting DTPicker to a null value
Check out this link...
http://www.microsoft.com/communities...xp=&sloc=en-us
--
HTH...
Jim Thomlinson
"vqthomf" wrote:
Hi I am using a DTPicker ctrl on a form and I am trying to set it to a null
value at form startup, I have used the code blow and this works but when the
user selects a date it wont show in the DTP box. Has anybody managed to solve
this problem?.
Regards Charles
With DTPicker1
.CustomFormat = " "
.Format = dtpCustom
End With
|