/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 vote127 views1 answer
Refresh token em vb net
VBA
1 vote139 views1 answer
Vb.net get name by Cell Click
VBA
0 vote127 views1 answer
Excel vba StartUpPosition
VBA
2 votes114 views1 answer
Vba uppercase first letter of each word
VBA
1 vote119 views1 answer
Excel vba make cell visible
VBA
0 vote123 views1 answer
Check if program is running vbnet
VBA
0 vote157 views2 answers
VB
VBA
0 vote134 views1 answer
Excel filter by date not working vba
VBA
0 vote122 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote131 views2 answers
Open url from vba
VBA