Excel Custom Questionnaire to File | VBA Macro #34
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. The Role selection options can be customized directly in the Roles Worksheet. Once a user selects their Role, they can click Generate to see what questions they need to complete to finish the questionnaire. Certain questions can display for specific Roles by indicating the questions number in the columns adjacent to a specific role in the Roles Worksheet. This helps ensures that only the questions that are necessary for users are completed. The questions and answers can be customized by updating the Questions Worksheet. Three questions types exist: Yes/No, List, and Free Text and can be set in the second row of the Questions Worksheet. When creating a List question enter the answers in the rows below. After a user has completed all the required questions, they can click Finish to create a separate Excel Workbook with all the populated answers. This new Excel Workbook will be saved to the same location as the Active Workbook. You can customize where this new file is saved making it easy to know when someone has completed a questionnaire and is awaiting review. By Default, the new Excel Workbook file name will be the Role selected followed by the Date and Time. 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. It is easy to restrict access to edit this questionnaire by protecting the Roles and Questions Worksheets with a password. To do navigate to the Review tab and click the Protect Sheet button.
#Excel #VBA #Macro
Checkout this Excel Macro page: https://leveragelean.com/macros/excel...
Find more content on our website: https://leveragelean.com
Watch all of our Excel Macro Videos on our YouTube playlist: • Excel VBA Macros [FREE]
Subscribe to our YouTube Channel to stay up to date on all of the videos we are posting.
/ @leveragelean
Like us on Facebook: / leveragelean
Follow us on Twitter: / leveragelean
Connect with us on LinkedIn: / brentschneider-leveragelean
Check us out on Instagram: / leveragelean
Leverage & Lean is focused on improving computer processes by Leveraging programming and applying Lean principles. It is our goal to make you more efficient and effective on your computer producing "Less Clicks and More Results!" To see our content visit LeverageLean.com where we have Visual Basic Applications (VBA) Macros in Excel, Outlook, and Word that automate repetitive computer tasks. You can start using this macro today for FREE, No Charge, No Gimmicks!!! Come visit us and watch our additional Macro Instructions videos to see how to implement our VBA macros in your computer processes and customize them meet your specific needs. Macros helps save time and time is money it’s as simple as that! Also, walkthrough our PDF Tutorials step by step or watch our See How videos to utilize computer settings that have been hiding in plain sight. Read our weekly Insights that open your mind and challenge you to start improving your computer processes. Leverage & Lean Insights are a quick read (less than 1 minute on average) but can be a great reset to your day and help you focus on how to start winning on your computer!
Stay Awesome,
Brent Schneider
Leverage & Lean
Est. 2017