Inserting a calendar macro in Excel

Asked By Mackenzie Castillo 0 points N/A Posted on - 04/05/2012

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? 

• Status: Open
• Question Views: 2819
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Tanok Bloran

Go To Solution

Best Answer

Best Answer

Answered By Tanok Bloran 80 points N/A #110870

Inserting a calendar macro in Excel

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:

• Create a workbook
• Point to Macro under the Tools menu
• Click on Visual Basic Editor
• Click Module under the Insert menu
• Copy the Visual Basic for Applications code you need into your module sheet
• Click Close and Return to Microsoft Excel on the File menu
• Click on the Sheet1 tab
• Point to Macro on the Tools menu
• Click on Macros
• Click on CalendarMarker
• Click on Run

For Microsoft Excel 2007 and 2010:

• Create a workbook
• Click on Visual Basic on the Developer ribbon
• Click on Module under the Insert menu
• Copy the Visual Basic for Application code you need into the module sheet
• Click on Close and Return to Microsoft Excel under the File menu
• Click on Sheet1 tab
• Click on Macros under the Developer ribbon
• Click on CalenderMarker
• Click on Run

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.

About Tanok Bloran

Questions
2

Answers
315

Best Answers
100

• Vote Up 0 Vote Down

• Posted on - 04/06/2012
• Question Category: MS Excel

Answered By theone1 0 points N/A #110872

Inserting a calendar macro 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

About theone1

Questions
0

Answers
40

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 05/19/2012
• Question Category: MS Excel