/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

-1 vote193 views1 answer
How to correct a number to 2 decimal places in vba
VBA
1 vote188 views1 answer
If inputbox cancel vba
VBA
0 vote186 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote192 views1 answer
Check if program is running vbnet
VBA
1 vote131 views1 answer
How to open cmd with vbd
VBA
0 vote191 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote172 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote222 views1 answer
Wpf dark title bar
VBA
0 vote187 views1 answer
Write listbox to text file vb.net
VBA
2 votes130 views1 answer
Excel vba pause
VBA