View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dianne Dianne is offline
external usenet poster
 
Posts: 107
Default Format textbox for dates

Harald,

I don't know about Lieven, but I would certainly be interested in having
a look at your code!

--
Thanks,
Dianne

In ,
Harald Staff typed:
Hi Lieven

Allow me to disagree with you -being a software designer and all :-).
You should imo let the user enter dates in whichever format she wants
and that the computer can recognize, and make your code validate it
and format it afterwards. I'm in dd-mm country too, and I allow my
users enter all kinds of things into my textboxes, most common are
1. Feb
feb
1.2
1.2-03
1-2-2003
1/3-03
1.2.2003
0102
010203
01022003
-and even
Week 5
Week 5 03

If this idea is of interest then post back and I'll dig up the code
for it from the vault.