/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 vote136 views1 answer
Sendkeys vba selenium
VBA
0 vote126 views1 answer
Vba DisplayGridlines
VBA
0 vote125 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
1 vote150 views1 answer
Extract the second word in a text in excel
VBA
0 vote126 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote143 views1 answer
Vba registry settings
VBA
0 vote135 views1 answer
Vba type variable
VBA
20 votes284 views1 answer
Excel vba factorial
VBA
1 vote126 views2 answers
Get all column names from excel vba
VBA
0 vote133 views1 answer
Get month number from month name vbnet
VBA

Share