Get data from Excel-cell and check format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!!!!!!!!
 
Why does the sheet have TEXT in these cells? Use data validation to
check for date, and set the format of the cells to the format you want.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Field in Pivot Table 3
Vba Date$ 1
Checking format on input 2
Dates 2
Excel is changing date format incorrectly 7
Date (dd/mmm/yyyy) 1
VB: date format in an Excel file 2
How to Get Date of Each Cell.... 6

Back
Top