• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

Excel VBA Create a popup calendar in Excel


How do I use Excel to create a popup calendar in Excel
that can be used to populate a cell value?

Murray Brown
Murray Brown
1 Solution
Saurabh Singh TeotiaCommented:
In order to create a calendar in excel, You need to create a user form first and then on that user form you can create a calendar to do what you are looking for by selecting calendar control on the same.

And then calling that userform at  event or button click to do the same.

You can refer here for more guidance on it as he is one of the MVP in excel who has given an easy to follow examples to create this..

Saurabh Singh TeotiaCommented:
Another Question on EE itself for the same..


Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Martin LissOlder than dirtCommented:
Here's a working example. Select the "Select me" cell.
Roy CoxGroup Finance ManagerCommented:
There's several examples here

Excel DatePickers

One of the examples demonstrates how to use the calendar form to add the date to a different UserFomr
Roy CoxGroup Finance ManagerCommented:
I forgot to say that the examples do not use ActiveX controls and will therefore work in most versions of Excel
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now