View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default Data passed to spreadsheet from Form. How to reload thespreadsheet data into the Form?

Hi

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

Regards,
Per

On 7 Maj, 04:43, Morlin wrote:
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.