Thread: Date Format in Userform
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter1999 Peter1999 is offline
external usenet poster
  
Posts: 1
Default Date Format in Userform

Hi,

I'm looking for a code to transform a number value in a userform to a
date value after enter is pressed. For example, in the UF, the user
would enter 010100, which would change to the date format 01-Jan-2000
after enter (or tab) is pressed or another cell selected. Any ideas?
Thanks in advance,

Peter


--
Peter1999
------------------------------------------------------------------------
Peter1999's Profile: http://www.excelforum.com/member.php...o&userid=33997
View this thread: http://www.excelforum.com/showthread...hreadid=549886

Reply With QuoteReply With Quote