Thread: Date dd-mm-yy(EXCEL) manipulation in VB macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nanda via OfficeKB.com nanda via OfficeKB.com is offline
external usenet poster
  
Posts: 2
Default Date dd-mm-yy(EXCEL) manipulation in VB macro
I want to manipulate date entered in excel sheet using VB macro, ie want to
extract day, moth and year separately from the date entered in EXCEL sheet
(in dd-mm-yy format )and store it in three different variables. but since the
formats used in excel is dd-mm-yy and VB is mm/dd/yy could any body please
code a function to do the same Thanks very much

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200908/1

Reply With QuoteReply With Quote