Let’s use the properties listed above in a sample program Example 1: VBA program to test whether the string is a valid email address Sub RegEx_Tester() Set objRegExp_1 = CreateObject("vbscript.regexp") objRegExp_1.Global = true objRegExp_1.IgnoreCase=true strToSearch=" " Set regExp_Matches = objRegExp_1.Execute(strToSearch) If regExp_Matches.Count = 1 MsgBox("This string is a valid email address.") End if End Sub While the “False” searches only the current line.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |