Macro to retrieve specific information based on one cell

[JRW520]

Hello forum!

I have a spreadsheet using an Input Form (user cannot get to the spreadsheet to enter data - they must use the form). This is working well.

What I need to do now is allow the user to retrieve data that is already entered. Example: Spreadsheet has 100 unique records (rows). In each is ID, Name, State, Dues, and about 20 other columns of information.

I need to allow the user to key the ID # and then up pops all the other information for just the ID provided. I will also need the ability for them to then change that information if needed.

So if they key 13WIL they will get Wilson, TX, $50, etc. And then they can make changes to any field needing a change. Add a phone, change and address, etc.

thank you for your time!

 

[Momentman]

I have a spreadsheet using an Input Form

Is it a userform or the windows form that you get from "all commands"?

 

[JRW520]

I believe the correct term for what I did is a User form. I used VBA to design the form.

 

[Momentman]

In your designed userform, you must have used textboxes as the input controls for the user to enter data? right.

1.you could just add a command button which when clicked,which looks for whatever ID has been keyed into the keyID field and uses a vlookup to populate the other textboxes
2. you could then have another command button which would be like an update button that the user clicks to update the record in the database.

Without seeing your userform structure, its a little difficult to say with certainty what should be done but i think this gives you an idea