Calendar Control

[Phil]

I am using Microsoft Office 2002. I would like to use the
calendar control on a spreadsheet so the end user could
select a day of the month and it open another spreadsheet
within the same workbook. I am not a programmer so any
help on how to do this would be greatly appreciated.
Thanks in advance.

 

[Ron de Bruin]

Hi Phil

See this page for maiking a userform with the control on it
http://www.fontstuff.com/vba/vbatut07.htm

If your sheetnames are named in this format
ActiveSheet.Name = Format(Date, "m-d-yyyy")

You can use something like this in the DblClick event of the calndar

Private Sub Calendar1_DblClick()
On Error Resume Next
Sheets(Format(Calendar1.Value, "m-d-yyyy")).Select
On Error GoTo 0
End Sub