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