View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Date picker on a form?

Hi Robert,

Am Wed, 14 Oct 2015 12:11:12 -0700 schrieb Robert Crandal:

What are some effecient ways to allow users to enter date
in the format of "mm/dd/yy" or "mm dd yy" on a text box
or form control?

I guess what concerns me the most are typo issues, or
circumstances when users enter typos or dates in the wrong
format.


a text box contains text. You have to check for typos and you have to
convert the text to a date if you want to calculate it.
I would prefer a Date and Time Picker or Calendar Control.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional