I have built a function that will find every instance of a record, and
then store those records in an array. What I would like to do is have
that information displayed in a window so that all the information
matching that record is displayed. I am relatively new to VBA and do
not know if this is even possible.

Here is the code that finds my records and sets them in the array:

Public Function BadgeSearch(myTXT As String, myCol As String, mycoL2
As String, myfiLler As Object)
'Searches for variable info that is provided by userform in the Master
List worksheet and returns the row value for updating

Badge = myTXT
Myrec = 3
myfiLler.Clear
ReDim myVal(0 To 0) As Integer
ReDim Myval2(0 To 0) As Integer
counTer = 0
Do Until Range(myCol & CStr(Myrec)).Text = ""
Do While (Range(myCol & CStr(Myrec)).Text = Badge)
If Range(myCol & CStr(Myrec)).Text = Badge Then
myfiLler.AddItem (Range(mycoL2 & Myrec).Value)
Myval2 = myVal
ReDim myVal(0 To counTer) As Integer
For z = 0 To UBound(Myval2)
myVal(z) = Myval2(z)
Next z
ReDim Myval2(0 To counTer)
myVal(counTer) = Myrec
counTer = counTer + 1
End If
Myrec = Myrec + 1
If Range(myCol & CStr(Myrec)).Text = "" Then
Exit Do
End If
Loop
Myrec = Myrec + 1
Loop
End Function