View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
UmpaL00mpa UmpaL00mpa is offline
external usenet poster
 
Posts: 1
Default User Forms data entry - MM/DD/YYYY

I have a custom user form that pops up during one of the macros I run. In one
text box the user has to enter a date. I would like to write some code so that
the user can only enter the date in the MM/DD/YYYY format - eg. 11/07/2004.
What is the VBA code for this? Any help would by appreciated. Thank you.