Inserting a calendar macro in Excel

Asked By 0 points N/A Posted on -
qa-featured

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? 

SHARE
Best Answer by Tanok Bloran
Best Answer
Best Answer
Answered By 0 points N/A #110870

Inserting a calendar macro in Excel

qa-featured

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 http://support.microsoft.com/kb/150774.

Answered By 0 points N/A #110872

Inserting a calendar macro in Excel

qa-featured

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

Login/Register to Answer

Related Questions