VBA form / VBA formulier

I have a problem optimizing an excelform that I made with VBA. Long story short:

I began programming this form but got stuck on a couple of things

through another excelforum someone helped me a lot, and upgraded my form in a way that is beyond my expectations but it still has a few glitches and the programming is now beyond my capabilities so I am stuck with a form that I like a lot but I do not have the skillset to tweak it.


What must the form do?:

Supervisors can use the form to register employees when they want to go to a training.
To receive subsidy and for analysis, I need some personal data (like birthdate, gender,....)

It occurs that you need to register multiple employees for the same training. The way the form is build, you need to fill the form for each employee, I would prefer it if I could choose multiple employees and just needed to fill the info of the training once.

And the second thing that's not optimal is the privacy. An employee's gender and date of birth should not be visible for every supervisor who fills the form, just for me afterwards to anonimize and analyze.


This form is made in "dutch" so I don't know if every word in the form is easy to understand, but I think it is. If not I'm glad to translate

If someone could help me to rectify these small problems, I would be very grateful


thomas

Hello Tsjallie,


this is just perfect! thank you again and again!!



greetings


thomas

Hello Tsjallie,

Sorry for the late reply, I've been busy

I typed the code in "This Workbook"module.


As you will see in the attachment, I've put 2 types of solution in the module (of course not at the same time when testing), neither of them worked. The one above made sure the document was protected, but when entering new data, there went something wrong, because it only saved one line nothing more, and furthermore when entering new data after that, it would overwrite the previous data.


The code below did nothing