/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 vote335 views1 answer
Search in richtextbox vb.net
VBA
0 vote349 views1 answer
Vba sort the data Z to A
VBA
3 votes378 views1 answer
Vba continue for each loop
VBA
0 vote362 views1 answer
Windows Forms dark title bar
VBA
0 vote350 views1 answer
Add text to combobox drop down vb
VBA
0 vote342 views1 answer
Vba get relative cell address
VBA
0 vote350 views1 answer
Excel vba clear filter
VBA
0 vote362 views1 answer
Find if year is leap year vb
VBA
0 vote470 views1 answer
Vba change active sheet
VBA
0 vote345 views1 answer
VBA Sleep Snippet
VBA