I want to create a macro that makes a calendar pop out when you want to enter a date in a cell. Â What do I have to install to make this happen? Â How do I do this step by step and which version of Excel do I need to have?Â
To create a calendar using a Microsoft Visual Basic for Macro that will prompt you for the month and year using a worksheet, you can try the steps below.
For Microsoft Excel 2003:
For Microsoft Excel 2007 and 2010:
If you wish to see the sample for the Visual Basic Procedure you may go to https://support.microsoft.com/en-us/help/150774/how-to-create-a-monthly-calendar-in-excel.
Hi Mackenzie castillo,
This is a very easy task I hope by following my procedure you will be able to make it
The work sheet change selection event.
Asthe name suggest the calendar appear as one change from one cell to the other.
It applies when one click, Mouse selection or tab.
Go to file click new to have new work sheet
Click visual basic in developers ribbon.
From insert menu click module
copy visual basic for application code to create calendar to the module sheet.
Select file then close and open normal excel worksheet.
Select tab for sheet one and from developer ribbon select macro.
Select calendar maker and then run to make calendar in Ms excel
