Learn the first steps to optimize any spreadsheet: https://www.excelpowerup.com/training'>https://www.excelpowerup.com/training
Take your Excel spreadsheets to the next level: https://www.excelpowerup.com/course'>https://www.excelpowerup.com/course
Get personalized professional support: https://www.excelpowerup.com/support'>https://www.excelpowerup.com/support

I added this date picker to my Excel spreadsheet in less than 5 minutes!
One of the biggest complaints people have about Excel is that it’s hard to use. That’s why I always strive to make my spreadsheets as userfriendly as possible.
A date picker can be a gamechanger for your spreadsheets because it simplifies the process of selecting dates, making data entry a delightful task.
In this tutorial, you'll learn how to set up this date picker from beginning to end. I’ll also teach you a VBA hack that can make the date picker popup only for date cells!


VBA CODE

'Put this procedure in your Worksheet's in the Microsoft Excel Objects folder
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

' Check if Active Cell format matches the "Short Date" number format
If ActiveCell.NumberFormat = "m/d/yyyy" Then
' If the Active Cell format is a date, make the calendar visible
ActiveSheet.Shapes("Calendar").Visible = True

' Change the position of the calendar to be just below and to the right of the Active Cell
ActiveSheet.Shapes("Calendar").Left = ActiveCell.Left + ActiveCell.Width
ActiveSheet.Shapes("Calendar").Top = ActiveCell.Top + ActiveCell.Height

' If the Active Cell isn't a date, make the calendar invisible
Else: ActiveSheet.Shapes("Calendar").Visible = False

End If

End Sub


Website: https://www.excelpowerup.com
Instagram:   / rebekahoster  
TikTok:   / rebekahoster  
LinkedIn:   / rebekahoster  


00:00 Introduction
00:49 Native Date Picker
01:53 Get Mini Calendar AddIn
02:29 How it Works
04:02 VBA Hack PopUp Calendar
07:01 Custom Date Format