mercredi 4 avril 2018

VBA Edit Userform Listbox using Excel Database

I've a database (5 column's and the row's are adaptive). This data is sorted as: Name, Surname, Date of Birth and Promotion year. I've also made an Userform based on a Listbox that can show this 4 informations.

Now i would like to edit this database using checkboxes and textboxes in the userform. I already made my userform but the problem persists in transfering the data of the userform (checkbox: true or false and textbox) into the database on the corresponding cell (of the right person).

Any idea how I should think or work on this? I already tried some stuff but i can't show up with a solution that can transfer AND the checkbox AND the Textbox information.

Greetz

Aucun commentaire:

Enregistrer un commentaire