/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 vote324 views1 answer
Excel vba automatic calculation
VBA
0 vote335 views1 answer
Vba check 32 or 64 bit
VBA
0 vote331 views1 answer
Vba code for cutoff time
VBA
0 vote365 views1 answer
Sort dictionary by key vba
VBA
3 votes321 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote342 views1 answer
Vba excel do not recalculate before save
VBA
0 vote354 views1 answer
Vba string
VBA
0 vote310 views1 answer
Excel vba existence of a file
VBA
0 vote353 views1 answer
Tester si une case est vide vba
VBA
0 vote358 views1 answer
Vbnet revrese the order of character in string
VBA

Share