| |

VerySource

 Forgot password?
 Register
Search
View: 26|Reply: 3

How to determine whether the search is successful in vba

[Copy link]

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-3-9 11:00:02
| Show all posts |Read mode
Ibid
Reply

Use magic Report

0

Threads

1

Posts

0

Credits

Newbie

Rank: 1

Credits
0

 China

Post time: 2020-3-26 13:33:13
| Show all posts
Just set a flag
Reply

Use magic Report

0

Threads

6

Posts

6

Credits

Newbie

Rank: 1

Credits
6

 China

Post time: 2020-6-3 10:00:02
| Show all posts
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
Reply

Use magic Report

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

 Author| Post time: 2020-6-4 14:15:01
| Show all posts
thank you
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list