/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 vote137 views1 answer
Excel vba existence of a file
VBA
0 vote145 views1 answer
Excel delete ever other vba
VBA
0 vote135 views1 answer
Handling a click event anywhere inside a panel vb
VBA
3 votes136 views1 answer
Extract the nth word from a text string
VBA
1 vote144 views1 answer
Vbs run
VBA
0 vote140 views1 answer
Excel vba automatic calculation
VBA
0 vote138 views1 answer
Excel vba prevent saving workbook
VBA
0 vote163 views1 answer
Vba cell all borders
VBA
5 votes86 views1 answer
Vlookup vba
VBA
0 vote144 views1 answer
Vb.net visible property dgv collumn not working
VBA

Share