i need a employee training tracker tool created in excel with all possible reports

[LUVYOGESH100]

i am developing a employee training tracker tool in vba.
In a vba form,i am trying to create a training requisition of the departments.

it has fields deptname,trainingname,list of employees ,requireddate,headname.

how to display employee id and name in a list box and mulitple select it.

how to add it in seperate rows in excel sheet along with other data like training name,date,deptname

can some help me please???

 

[dmt32]

Hi, Welcome to forum.
Your project could involve some extensive VBA coding depending on functionality you require to build in.

As a suggestion, rather than start from scratch, consider searching around to see how others have approached the requirement & maybe one of these could be adapted to assist in your project requirements.

Here are couple of site suggestions:

https://chandoo.org/wp/training-tracker/

https://www.knowledgewave.com/blog/excel-has-a-built-in-training-log-template




Also, if you are new to userforms then this site always worth a visit: https://www.contextures.com/xlUserForm01.html

All sites offer free download of example workbooks.


Hope helpful, others here may be able to offer further suggestions.

Dave