/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

3 votes346 views1 answer
Extract word in a text in excel
VBA
0 vote323 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote326 views1 answer
Vba run command
VBA
3 votes323 views2 answers
Vba active workbook path
VBA
0 vote301 views1 answer
Excel vba scroll to cell
VBA
0 vote296 views1 answer
Check range is in another range vba
VBA
5 votes305 views1 answer
Excel vba how to unit test vba code
VBA
1 vote312 views2 answers
Vba function return array
VBA
0 vote314 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote304 views1 answer
Label de tableau dans des label.text en VBA
VBA

Share