Calendar Control
 

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.

Calendar Control
 

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




--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Phil" wrote in message ...
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.