How to retrive data using a form?

[albertc30]

Hello everybody.

I have this spreadsheet with some vlookup functions.

All works as it should but now I need to do the following;

I have designed a form and by typing a code on the first and only active field, I want to return all data relevant to this data on the other fields.

So for example;

Fields are; name, street, post code, town, contact, e-mail.

The form active field is name. All other fields are not active but I want to display the informatioin that relates to whatever name input on the active field.

How can i go about this using VBA.

My VBA knowlodge is less than basic.

Any help much apreciated.

Cheers,
Albert.

 

[albertc30]

Because you have the sheet protected and didn't give me the password!

Why would you type it in when it's in a dropdown list?

Hi everybody.

The reasson to type is that there will be so many names, like 1000's, that it's going to be faster to type and look for it that way.

Cheers,
Albert

 

[DonMac]

In the workbook I gave you, you can start typing and the autocomplete kicks in.

Its not too difficult to add an advanced filter to narrow the results down if you're looking at 1000s of records.