View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SamanthaK SamanthaK is offline
external usenet poster
 
Posts: 8
Default Get data from Excel-cell and check format

Hi! I am writing a macro for a spreadsheet. You are supposed to write two
dates into the spreadsheet in two different cells. When a button is pressed
the program shall read the text in the cells and check to see if they are in
the right format e.g. 2006-06-14 and not 06-06-04 i.e. YYYY-MM-YY.
Help!!!!!!!!!!!
--
I am very thankful for any fast assistance!