VBA Lookup problem...

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

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

this would be VB code that included:

Please Login or Register  to view this content.

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
---

Originally Posted by 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

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