How to retrive data using a form?

albertc30

Well-known Member
Joined
May 7, 2012
Messages
1,088
Office Version
  1. 2019
Platform
  1. Windows
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.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

x_ampl1

Board Regular
Joined
Mar 7, 2012
Messages
126

ADVERTISEMENT

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

Well-known Member
Joined
May 7, 2012
Messages
1,088
Office Version
  1. 2019
Platform
  1. Windows
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...
 
Last edited:

Tinbendr

Well-known Member
Joined
Jul 21, 2010
Messages
997

ADVERTISEMENT

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

Tinbendr

Well-known Member
Joined
Jul 21, 2010
Messages
997
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

Well-known Member
Joined
May 7, 2012
Messages
1,088
Office Version
  1. 2019
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,118
Messages
5,640,216
Members
417,131
Latest member
Seanr19871

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top