Calendar Control

  • Thread starter Thread starter Phil
  • Start date Start date
P

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.
 
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
 
Back
Top