Insert Drop Down Calendar In Excel 2025 Without Date Picker Vba. When i click on a cell, a calendar should pop up and i should be able to pick a date from the calendar. Oftentimes, users want to click a button and select a date.

This is no different for excel developers. Click in a cell where you want to enter a date.