/VBA/Excel vba check if string entirely alpha

Excel vba check if string entirely alpha

Excel vba check if string entirely alpha

'VBA function to check if string is ENTIRELY alpha:

Function IsAlpha(s) As Boolean
    IsAlpha = Len(s) And Not s Like "*[!a-zA-Z]*"
End Function

2

Source: academy.excelhero.com

Similar codes

0 vote229 views1 answer
Excel vba disable copy paste
VBA
0 vote247 views1 answer
Vba code for cutoff time
VBA
0 vote250 views1 answer
How to get value from clipboard in vbnet
VBA
5 votes269 views1 answer
Vba low byte from INTEGER
VBA
1 vote184 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote238 views1 answer
Vba add month to date
VBA
0 vote242 views1 answer
Vbnet line graph smooth lines
VBA
0 vote248 views1 answer
Excel filter by date not working vba
VBA
0 vote302 views1 answer
Wpf dark title bar
VBA
5 votes244 views1 answer
Excel formula how to create strings containing double quotes
VBA

Share