Date perfection with Excel tips and tricks - Step 4

Welcome to another Excel video! This is Step 4 on how Excel can help with dates and how to build dynamic calendars. Our step-by-step guide continues with more Visual Basic where will add a button for the user to reset the contents of the date checker with easy to follow explanation of the code to automate your spreadsheets for your users.
#excel #exceltricks #neurodiversity #microsoft #fyp #dates #datefunction #excelformula #visualbasic #calendar

Delivered by @Changetipsandtools

This video contains:
00:00 - Intro
00:20 - Add a Key to our day checker
05:24 - Create a Reset Contents button
06:39 - Write the Reset visual basic code for our button
08:01 - Declare a variable to capture the users response to message box Yes / No question
08:15 - How to request and capture a user response with a message box
09:45 - Code for a "Yes" answer from the user, to Reset Contents on the Date Checker
16:58 - Code for a "No" answer from the user, to Reset Contents on the Date Checker
18:30 - Overview of what the code is doing
19:04 - Assign macro to Reset Contents button
19:21 - Test and fix errors in code or sheet