/VBA/Excel vba check if a string only contains alpha characters

Excel vba check if a string only contains alpha characters

'VBA function to test if a string contains only letters:

Function IsAlpha(s) As Boolean
    IsAlpha = Len(s) And Not s Like "*[!a-zA-Z]*"
End Function

Source: academy.excelhero.com

Similar codes

3 votes145 views1 answer
Vba folderexists
VBA
0 vote200 views1 answer
Vba excel do not recalculate before save
VBA
0 vote147 views1 answer
Vbnet get file name from path
VBA
0 vote142 views1 answer
Vb.net round to 2 decimal places
VBA
1 vote171 views1 answer
Extract the second word in a text in excel
VBA
0 vote148 views1 answer
Excel vba current folder
VBA
0 vote162 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote157 views1 answer
Vba type variable
VBA
0 vote145 views1 answer
Vba verticalalignment
VBA
0 vote151 views1 answer
Vbscript check if string is empty
VBA