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]

I have designed a form ...

What kind of form. Userform? Form outline on a sheet?

 

[albertc30]

What kind of form. Userform? Form outline on a sheet?

The form was done using VBA within the same spreadsheet. Hope it helps...

 

[Tinbendr]

Nope, not at all.

 

[x_ampl1]

attach the worksheet
i had done one for my patient looks like yours
what i understand from you that:
you need to retrive each custumer in seperet sheet acording to your data base sheet

 

[albertc30]

attach the worksheet
i had done one for my patient looks like yours
what i understand from you that:
you need to retrive each custumer in seperet sheet acording to your data base sheet

Hello everybody.

Sorry if I wasn't clear enough but I might not know technical terms as such but please, here it is a sample of what I am trying to achieve.

Cheers,

Albert

P.S: Sorry guys but I'm either asleep still, as I can't see a way to attach my file or I am blind!!! I can see the insert video and image...

 

[Tinbendr]

Ypu'll have to use a service like box.com or google docs, etc.

 

[albertc30]

Ypu'll have to use a service like box.com or google docs, etc.

Please download the file from;

http://www.pchometech.co.uk/testing.xlsm

Thanks

 

[Tinbendr]

OK, now, how do you want it to operate.

Do you want the userform to display after picking a name from the validation list?

Do you want a dropdown list like the validation list, just on the userform?

Or ditching the userform all together, do you want the validation cell to have a comment cell with the selected data?

 

[albertc30]

OK, now, how do you want it to operate.

Do you want the userform to display after picking a name from the validation list?

Do you want a dropdown list like the validation list, just on the userform?

Or ditching the userform all together, do you want the validation cell to have a comment cell with the selected data?

Hi.

I could have a dropdwon on the form field to pick a name or/and could also type it to look for it.

But I do want the form.

Any help well apreciated.

Cheers.