Look Up Data and Plug into Form - User Form in Reverse?

[Leah]

This is a general question to see if this is possible before I start to think through the project:

I have created a registration workbook for this year's youth sports league. All of the information is entered into a User Form and separated onto it's appropriate sheet designated by the child's age.

Next year, I would like to use this year's workbook to look up returning players.

Will it be possible to add a "lookup" button into my form, or create a lookup program, that once the registrar clicks on the correct player, the information is plugged into the User Form, the registrar adjusts the age and any necessary info, presses enter, and the information is copied into the appropriate category in the new workbook?

I haven't worked with User Forms long enough to know if they can be filled in that way, but if this can be done, you are the people who would know.

Thank you,
Leah

[rylo]

Leah

Yep this is possible. There are various posts on this forum that covers this sort of thing so you should be able to search and get some idea of what to do.

rylo

[royUK]

Look at the DatabaseForm example here:

http://www.excel-it.com/vba_examples.htm

[Leah]

Thank you both very much. I especially appreciate the example. Once again, this place saved me a headache.