How do I make my Excel calendar pop up for multiple columns? - Excel Tips and Tricks - video Dailymotion

RabiGurungXybernetics

Discover how do you make an excel calendar pop up   🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗  How do I make my Excel calendar pop up? - PART 1 - Excel Tips and Tricks  https://youtube.com/shorts/n4bya-Jds_g?feature=share   How do I make my Excel calendar pop up? - PART 2 - Excel Tips and Tricks  https://youtube.com/shorts/239ITbMUbhw?feature=share   How do I make a clickable calendar in Google Sheets? - Excel Tips and Tricks  https://youtube.com/shorts/mCog_mBsxRo?feature=share   How do I make my Excel calendar pop up for multiple columns? - Excel Tips and Tricks  https://youtube.com/shorts/Nco59X0FSow?si=B-THBk69Y-BmiK_l   How do I make my Excel calendar pop up? - UPDATED - PART1 - Excel Tips and Tricks  https://youtube.com/shorts/r_KvJq4Dp34?si=Scc4BvnbqQjMCNZy   How do I make my Excel calendar pop up? - UPDATED - PART2 - Excel Tips and Tricks  https://youtube.com/shorts/mDG2y5Uddi8?si=ufxUVFsZh9tHPBzn   Popup Calendar in Excel - Excel Tips and Tricks  https://youtube.com/shorts/hnNQhgDBR_w?si=d8GrpEfdfwg_2S5X   How do I make my Excel calendar pop up in any cell? - Excel Tips and Tricks  https://youtube.com/shorts/2pL3XrW_jCo?si=hkWqNe7r8kEjZhUH    Discover how do you make an excel calendar pop up?Another way to ask is how do I create a date picker in VBA? Some people like to ask is how to use Datepicker in VBA Excel? Another way, how do I make a date picker on Excel VBA? Or how do I open a date picker in VBA?

Transcript

00:00I recently posted a video on how to make a pop-up calendar in Excel, but someone

00:03had a question regarding about doing the same thing for columns that are not in

00:07series. For instance, column D, F, and H. You have to make a minor edits to your VBA

00:12and this is how you do it. For this spreadsheet here, I'm gonna put pop-up

00:16dates for column D, F, and H. You're gonna right-click on your sheet here, view

00:21source code. This is the original source code that I presented in my last video.

00:24All you have to do is you have to put a union and then open parenthesis and then

00:30after that you're gonna change this to D, comma, and then you're gonna release all

00:35the different columns that you're gonna have. Once that's done, Ctrl S to save it.

00:43If you do need this script to be sent out to you, leave me a comment and I'll send

00:48the script to you. Close this VBA editor and now column D has a pop-up, E doesn't

00:53have it, F has a pop-up, G doesn't have it, and H has a pop-up.

How do I make my Excel calendar pop up for multiple columns? - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended