/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 vote134 views1 answer
Vba exit while
VBA
0 vote133 views1 answer
Return na vba
VBA
1 vote146 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote117 views1 answer
Vb.net round to 2 decimal places
VBA
1 vote120 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote117 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote128 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
1 vote119 views1 answer
VBA Loop through recordset
VBA
3 votes137 views1 answer
Vba double quote
VBA
1 vote125 views1 answer
Excel how to format bytes as KB, MB, GB
VBA