Calendar in Excel


Sometime we love to have calendar in Excel. You can display a calendar in a excel sheet and enter date in a cell by selecting the appropriate date. Follow the given steps :-

1. Open excel work book.
2  Go to view>Toolbars>Control Toolbox
3. Now you can see a toolbox window in the sheet. Go to last button (more control) and click on it. Here u can see a list of controls, click on Calendar control.
4. Adjust the calendar in the sheet where you required to be displayed this.
5. Double click on calendar or right click, then view code, you will find following code in coding window:-

Private Sub Calendar1_Click()

End Sub

6. Enter following line between 1st and last line

ActiveCell.Value = Calendar1.Value

7. Your code will look like this :_

Private Sub Calendar1_Click()
ActiveCell.Value = Calendar1.Value
End Sub

8. Come out of VBA window and go to excel sheet and use the calendar.

One thought on “Calendar in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>