Sub myAlphanumstring()
' ______________________________________
'
' This works both in Excel and Word VBA
' ______________________________________
Dim myAlphanumstring As String
myAlphanumstring = "a142b"
If myAlphanumstring Like "*###*" Then
MsgBox "yes"
End If
End Sub
No comments:
Post a Comment
You may comment or show me other VBA tricks, but don't rest assured I'll always reply because I only have 24 hours in a day's hard work, and only a few minutes a week to update this blog... I'll try my best though...