Data passed to spreadsheet from Form. How to reload the spreadsheetdata into the Form?

[Morlin]

I am creating a user form to track training at work for multiple
employees.

I created a userform to enter the data and figured out how to enter
that data into a spreadsheet by creating a submit button.
Here's where I need help.....
I want to be able to lookup by employee ID#, using a search button on
the userform that will allow it to autofill all of the information
back onto the userform so I can make updates and or changes to an
individuals training dates or classes or whatever the specific data
is. Then to be a bigger pain in the butt. I want to be able to hit
"submit" on the userform and have the info on the spreadsheet updated
with the new info.

Can anybody help? I taught myself all of the stuff I have done so
far
but, I am totally stuck.

If anybody is willing to help I would greatly appreciate it.

 

[Per Jessen]

Hi

We need more information on layout of your userform and worksheet, to
give any usefull guidance.

Regards,
Per

 

[Morlin]

Hi

We need more information on layout of your userform and worksheet, to
give any usefull guidance.

Regards,
Per






- Show quoted text -

Ok. forgive me if it's not given in technical phrases.

My userform is laid out by Serial #, last name, first name with text
boxes for each. As well as 6 text boxes that dates are loaded into.
when I hit submit it lists the exact text or dates i typed into the
spreadsheet.

I then list mandatory training by title with check boxes 44 total
check boxes. When I hit submit each one records 1 in the spreadhseet
for number of hours credit the student recieved for the training
class.

The final section of the Form is textboxes that I enter a class name
in one text box and # of hours for various other classes in the next
box. The hours and the class record when I hit submit.

All of these are laid out so I hit submit once everything is entered
and it records them in the appropriate colum with a submit button that
I figured out how to create the code for.

The spreadsheet itself is just columns across "A" through "CD"

Serial # Last Name First Name Drivers License Exp Taser Exp Pepper
Ball Exp Firearms Exp Milo Comp Module Comp CPR Exp

It continues I just wanted to give an example.


I want to be able to add a button labeled "Look Up". I want to be
able to search for an employee Serial # and have it pull the
information back from the spreadsheet and refill the form with the
correct data for each text box in the form.

If anybody wants to see what it is i've done so far directly let me
know and I can e-mail them directly what I've done so far. (unless
that goes against the user agreement on the group....i'm new and
haven't read them)

 

[Per Jessen]

Hi

You can mail me the workbook if you want, but I will first have time
to look at it tomorrow.

PerJessen69AThotmailDOTcom

Regards,
Per

 

[Matt Cooper]

I'm looking to solve a similar problem I'm having; did you ever find a
solution?

Matt

 

[Patrick Molloy]

don't close the form, HIDE it

or save the form's data to a hidden sheet & repopulate when its shown again