Keith
Registered User.
- Local time
- Today, 01:56
- Joined
- May 21, 2000
- Messages
- 129
I have 4 command buttons on a worksheet named 'Calendar' that I want select the quarter. The calendar is populated from a worksheet named 'Calcs'. I am having difficulty in setting the start date on the Calcs worksheet. Leave_Year is a named range in worksheet 'Input' and is general format containing the year ie. 2008
The code that I have is:
Private Sub cboAprJun_Click()
Worksheets!Calcs!C1.Value = DateValue("Leave_Year,4,1")
End Sub
I get the following error; Runtime Error 13 Type mismatch
It's probably something simple but my feeble brain is struggling.
The code that I have is:
Private Sub cboAprJun_Click()
Worksheets!Calcs!C1.Value = DateValue("Leave_Year,4,1")
End Sub
I get the following error; Runtime Error 13 Type mismatch
It's probably something simple but my feeble brain is struggling.