Use VBA Regex to find mulitple matches between two same key words

Say if I have a text that is segemented into sets by keywords
And I want to find the matches between the keyword set.

For example, a complex string like: “gfdgfsdhfs Set 415468498 Set
65576dsadas&^$# Set“

I want to find the matches between those sets into

gfdgfsdhfs Set 
415468498 Set
65576dsadas&^$# Set

I know I can use left function to write into a string array,
but I am just curious if there is regex expression to be executed into match collection.

The test site I am using is regex101.com/

I have tried this method Set.*Set
but all I get is one match from the first Set to the last Set

Read more here: Source link