I've got a staff manager type thing that I'm working on. Essentially there is a database stored in a sheet with staff details. This includes contact information, leave balances, Next of Kin details etc.
I've got a userform called frmRegistration that searches and displays the results.
The results are displayed as Caption Labels rather then text boxes on the form.
Its based off https://www.onlinepclearning.com/staff-database-excel-awesome-userform-database/
but instead of text fields I have used captions because im only displaying data not editing/adding it.
What I want to do from here is to click a button which will let me decide which data (staff contact, NOK, leave balances etc) to paste into another sheet so I can create a PDF out of it.
What Im not sure about is
a) how do I create a tick box system to decide what data I want to print (another userform with check boxes?)
b) how do I then take text.captions values from my previous userform and paste them into a template sheet ready to be converted into a PDF for printing.
This forum doesnt allow me to post attachments...
I've got a userform called frmRegistration that searches and displays the results.
The results are displayed as Caption Labels rather then text boxes on the form.
Its based off https://www.onlinepclearning.com/staff-database-excel-awesome-userform-database/
but instead of text fields I have used captions because im only displaying data not editing/adding it.
What I want to do from here is to click a button which will let me decide which data (staff contact, NOK, leave balances etc) to paste into another sheet so I can create a PDF out of it.
What Im not sure about is
a) how do I create a tick box system to decide what data I want to print (another userform with check boxes?)
b) how do I then take text.captions values from my previous userform and paste them into a template sheet ready to be converted into a PDF for printing.
This forum doesnt allow me to post attachments...
