This is an Excel macro that generates a custom questionnaire to complete. The Role field is used to determine what questions display for specific users. Once a user selects their Role, they can click Generate to see what questions they need to complete to finish the questionnaire. After a user has completed all the required questions, they can click Finish to create a separate Excel Workbook with all the populated answers. You can customize where this new file is saved making it easy to know when someone has completed a questionnaire and is awaiting review. There is also the option to send this separate Excel Workbook in an Outlook email with a couple updates to the VBA code. There is always a better way with VBA and this Excel macro helps standardize the collection of answers to specific questions. This can help lead to a more formal review process and eliminate mistakes.
First time using VBA?