kellyhell
10-04-2010, 04:18 AM
I am attempting to set validation on a cell based on 2 criteria.
The user can either input data into a cell but it must meet the following format:-
AB123456C (i.e. 2 letters, 6 numbers then a letter) or 12/03/1967 (i.e a date of birth using the "/" as a separator.
Any other format is not allowed as a VLOOKUP is used based on what is input to this cell.
I have looked at using a formula in Data>Validation and cannot work it out.
Is there such a formula or any VBA which would do it?
TIA
The user can either input data into a cell but it must meet the following format:-
AB123456C (i.e. 2 letters, 6 numbers then a letter) or 12/03/1967 (i.e a date of birth using the "/" as a separator.
Any other format is not allowed as a VLOOKUP is used based on what is input to this cell.
I have looked at using a formula in Data>Validation and cannot work it out.
Is there such a formula or any VBA which would do it?
TIA