Date perfection with Excel tips and tricks - Bonus Video

Welcome to another Excel video! This is a BONUS video on how Excel can help with dates and how to build dynamic calendars. In this bonus video using Visual Basic we will move a shape dynamically to improve the user experience!! No more searching for buttons 🚀
#excel #exceltricks #neurodiversity #microsoft #fyp #dates #datefunction #excelformula #visualbasic #calendar #arrays

Delivered by @Changetipsandtools

This video contains:
00:00 - Intro
00:24 - Overview of what we will do in this video
00:42 - Unprotect sheet
00:51 - Use the View Pane to get our shape name
01:07 - Create some Visual Basic code to capture the position of our shape
06:13 - Map out column ranges for button pre-set positions
08:03 - Visual Basic to move button dynamically based on cell selected the 'SelectionChange' procedure