Copy Data from Database to Input Sheets Using Userform Selection

Hi,

Currently I have a button in the database (DB) sheet that will transfer the active row data in the DB to the input sheets.

What I would like to do instead is to do that via the userform - so when I to select a "student" in my userform (Resultbox which displays all students when you click the All Students button) and click the Load Student Info button then it will copy the data of that specific student (refering to student number displayed in ProID box) from the DB with same student number in the DB to sheets "Input 1" and "Input 2" and then unload the userform and open "Input 1" sheet.

I have attached the workbook for reference.

Thanks

Paste the code in, only needs the selection from the listbox - activates on the mousebutton_up event.

Please Login or Register  to view this content.

Originally Posted by torachan

Paste the code in, only needs the selection from the listbox - activates on the mousebutton_up event.

Hi torachan, thanks but this is not going to work for me, I really do need it to work when I press the button.

Is this the long way round you want it to work.
First select in the listbox then press the Load Student Info button to load the two sheets

Originally Posted by torachan

Is this the long way round you want it to work.
First select in the listbox then press the Load Student Info button to load the two sheets

Haha yes that is exactly what I need to happen - the long way - thanks

How would the code work to rather have the

Please Login or Register  to view this content.

section all in a module that could the be called up to run, like I have in Module 2? Maybe Use Module 3 for this section of code.

The reason I say this is that this workbook shared here only has these 17 entries but my actual project workbook has over 750 entires that need to load and I am not sure that it is best practice to put all 750 of these

Please Login or Register  to view this content.

entries into the userform code?