VBA Lookup problem...

[Stuie]

basically i got a database that i have made user forms for data entry and i want to use a form which will retrieve the records based of a criteria... i have tried vlookup but it will only retrieve the first record example...

name ¦ surname ¦ age ¦
john ¦ doe ¦ 58 ¦
bob ¦ smith ¦ 24 ¦
john ¦ doe ¦ 23 ¦

now what i need is a function that would return both john doe records instead of just the first one if i searched by the surname.

if any1 has a answer it wud be most appreciated

[Bryan Hessey]

Did you mean that you want to populate a listbox within the UserForm?

this would be VB code that included:

     Erase MyArray
    On Error GoTo noItems
    Set rSearch = Worksheets("Inspections").Range("A4", Range("a65536").End(xlUp))
        strFind = Me.ListBox2.Value
        With rSearch
            Set c = .Find(strFind, LookIn:=xlValues)

plus, of course, many other lines to the box.

VLookup is used in Formula, and normally returns one value for the current cell (the cell that contains the VLookup).

hth
---

basically i got a database that i have made user forms for data entry and i want to use a form which will retrieve the records based of a criteria... i have tried vlookup but it will only retrieve the first record example...

name ¦ surname ¦ age ¦
john ¦ doe ¦ 58 ¦
bob ¦ smith ¦ 24 ¦
john ¦ doe ¦ 23 ¦

now what i need is a function that would return both john doe records instead of just the first one if i searched by the surname.

if any1 has a answer it wud be most appreciated

[Stuie]

cool thanks mate i will give tha ago when i get home