/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

0 vote321 views1 answer
Add text to combobox drop down vb
VBA
0 vote296 views1 answer
Vba file size
VBA
1 vote308 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
1 vote308 views1 answer
Excel vba first row in range
VBA
0 vote329 views1 answer
Add text to Shape VBA
VBA
5 votes370 views1 answer
Vba low byte from INTEGER
VBA
0 vote287 views1 answer
Excel vba formatconditions range
VBA
5 votes320 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote320 views1 answer
Send webhook vbscript
VBA
1 vote336 views1 answer
Excel how to format bytes as KB, MB, GB
VBA