MAcro for validation of Date

  • Thread starter Thread starter junx13
  • Start date Start date
J

junx13

Hi,

Anyone know how I can write a macro to set validation on a cell suc
that it will validate whether the date entered is of the form "dd mmm
yyyy" and that it is greater than the date today?

How do I programmatically set the error message?

Thanks for your help
 
Hi
a non-VBA solution. Try: 'Data - Validation' and choose 'Date' together with
your starting date.
 
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

Validating dates in a cell 3
Excel is changing date format incorrectly 7
Conditional Validation In Excel 1
best way to validate data in forms; 2010 1
International Date formatting 4
Dates converted into text 5
Problem with date formatting 5
Input message problem for Date textbox 4

Back
Top