DATA VALIDATION

N

Nick

I NEED TO VALIDATE ENTRIES.
EACH ENTRY CONSIST OF A NUMBER AND A LETTER
LIKE 6A OR 6B.
A, AND B TO BE ACCEPTED ONLY IF THEY ARE FROM THE ENGLISH ALPHABET
 
A

AlfD

Hi!

Do you mean a single digit (0...9) and a single letter( A...Z) ?

If so, one simple way is to create a data validation list with all th
possible combinations. The following very basic VBA routine will pu
such a list in column A.

Sub fillit()

r = 1
For i = 0 To 9
For j = 1 To 26
Cells(r, 1) = i & Chr(j + 64)
r = r + 1
Next
Next


End Sub

Are you familiar with Data > Validation?

Al
 
Top