How to determine whether the search is successful in vba

wingcat

Ibid

zjwzri

Just set a flag

蜘蛛蝎

I do not understand what you mean
MsgBox("Successful")

Dim regex, matches, match, found 'declare variables
Set regex = New RegExp 'Create object

regex.Pattern = ""

Set matches = regex.Execute("your string")

For Each match in matches
    found = match.Value

    '' Follow-up operation
    '...
Next

wingcat

thank you