Create a visual basic form which captures new joinee details (Name, address, department, email etc) and saves it in proper dataset in excel. Note: Assign a macro to the "Submit" button
Dear Karan,
We actually have a great article and a video tutorial that might be just what you're looking for. I've included the Excel file from that tutorial which has a UserForm that allows you to enter various details like names, designations, and even photos of your employees! And the best part? All the data entered is securely and safely stored in a database. Plus, there's a handy Employee Search Box that makes it super easy to find any employee's details just by using their ID.
If you have any further queries, feel free to ask.