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.

 

[Tinbendr]

OK, take a look at this. :Let's see if we're both on the same page.

 

[albertc30]

OK, take a look at this. :Let's see if we're both on the same page.

Hello.

Not quite I'm afraid.

I want to use the form and type a customer name or select it from the dropdown list and the values (as in vlooup) will be returned on the forms other non active fields.

Hope my explanation is better this time.

Thanks for your time and help.

Albert

 

[Tinbendr]

OK d/l the file again and see if we're closer.

 

[albertc30]

OK d/l the file again and see if we're closer.

Hello.

We are indeed making progress.

Somehow I don't know why I have a sheet three.

The form is to do the same as in sheet 2.

Just type in a name on the first cell (other will only return a value if existing so therefore not active cells).

Cheers,
Albert

 

[Tinbendr]

Somehow I don't know why I have a sheet three.

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

Just type in a name on the first cell

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

 

[DonMac]

Is this the sort of thing you're looking for?

https://dl.dropbox.com/u/61290084/MrExcel1.xlsm

 

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

Ops... Sorry...

The password is 5.

 

[albertc30]

Absolutelly.

I can use this one and see how it works.

Thanks.

 

[DonMac]

You're welcome. If you need any help understanding whats going on, just ask.

Don.

 

[DonMac]

I've just made a couple of minor alterations to the names used. You can download the latest version.