regexp to find multiple instances of the same structure term?

I have a string (filename, actually), that I want to see how many instances there are of XNNNN and/or XNNNNN, where N is a numerical digit.

For example, if filename is "N1234 and N22522 - Content", then I would like to know that there are 2 matches and be able to analyze the 2 matches.

I have it working for a single match, as follows:

Code:

---

    Dim nNumberPattern As String
    nNumberPattern = "(N[0-9]{3,}).*Content(s?).*"
    Dim nNumberMatches
    Dim nNumber As String
   
    With nNumberRegEx
        .Global = True
        .Pattern = nNumberPattern
    End With
       
    ' Let's find the n-number that we are working with (using the file's name)
    If nNumberRegEx.Test(myWorksheetObj.Parent.Name) Then
        Set nNumberMatches = nNumberRegEx.Execute(myWorksheetObj.Parent.Name)
        nNumber = nNumberMatches(0).SubMatches(0)

---

How can I adapt this to identify that there are 2 matches when filename is "N1234 and N22522 - Content" and then be able to read/access/use each of "N1234" and "N22522"?

Even though you have .Global set to TRUE, it will still only find one match because of the .*Content(s?).* bit of the pattern; your file name will only have one of those bits, so there will only be one match.
Remove that end bit from the pattern and you'll have both/all your matches.
I don't know regex well enough to suggest a search pattern that will return those matches and ensure that the filename contains Contents after the matches; maybe check for that independently in another line of code (Instr, InstrRev, Find, Search, etc.).
You'll be able to run through the matches with the likes of

Code:

---

For Each nNumberMatch In nNumberMatches
  MsgBox nNumberMatch.Value
Next nNumberMatch

---