/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 vote236 views1 answer
Vba format currency
VBA
0 vote243 views1 answer
Open file dialog in vb.net
VBA
1 vote248 views1 answer
Perform http request in vb.net
VBA
1 vote233 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote249 views1 answer
VBA Loop to range
VBA
5 votes258 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote223 views1 answer
Type excel.application is not defined vb
VBA
1 vote230 views1 answer
Vba refresh pivot table
VBA
1 vote248 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
4 votes240 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA

Share