/VBA/Excel vba check if a string only contains letters

Excel vba check if a string only contains letters

'VBA function to test if a string contains only letters:

Function IsAlpha(s) As Boolean
    IsAlpha = Len(s) And Not s Like "*[!a-zA-Z]*"
End Function

Source: academy.excelhero.com

Similar codes

0 vote182 views1 answer
Excel vba first working day month
VBA
0 vote223 views1 answer
Windows Forms dark title bar
VBA
0 vote182 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote168 views1 answer
Handling a click event anywhere inside a panel vb
VBA
32 votes254 views2 answers
Excel vba column letter
VBA
8 votes175 views1 answer
Excel vba make a short integer from two bytes
VBA
18 votes259 views3 answers
Excel-vba make integer
VBA
0 vote183 views1 answer
Vba leading zeros in string
VBA
0 vote183 views1 answer
Vba add month to date
VBA
0 vote193 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA