/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 vote149 views1 answer
How to self delete a vbscript file
VBA
20 votes317 views1 answer
Excel vba recursive example factorial function
VBA
0 vote170 views1 answer
Excel vba hide columns
VBA
0 vote168 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote181 views1 answer
Excel vba convert cells address
VBA
0 vote168 views1 answer
Openfiledialog specific folder
VBA
0 vote164 views1 answer
Vbnet hex to binary
VBA
0 vote174 views1 answer
Vba exit while
VBA
0 vote160 views1 answer
Excel vba disable copy paste
VBA
0 vote188 views1 answer
Vba random number
VBA