/VBA/Excel vba check if a string only contains alpha characters

Excel vba check if a string only contains alpha characters

'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 vote183 views1 answer
VBA check if a cell contains a letter or string
VBA
5 votes155 views1 answer
Vba array worksheet.index
VBA
0 vote181 views1 answer
Vba apostrophe chr
VBA
0 vote179 views1 answer
Excel vba range contains
VBA
0 vote185 views1 answer
Vba loop through textboxes
VBA
0 vote194 views1 answer
Group controls programmatically vb
VBA
0 vote187 views1 answer
Vbs expand env var
VBA
0 vote269 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote181 views1 answer
Excel vba linter
VBA
0 vote184 views1 answer
Sort dictionary by key vba
VBA