Search box using vba

[Thecraftycarrot]

i currently have a search box set up that works, i type in a persons name and then a search box appears under the typed selection with all the possible names it could be.

However what i would like to do is now - is when typing in i would like to search i want more than one column to appear in the drop down to help make a more informed selection

- e.g. - Search = dave

Drop down would be:

Dave Davidson | Manager
Dave Dorris | Cleaner

etc.

Can anyone provide some insight into how i would go about this?