Excel 2010 calendar control issue

Hi pandey,

Could you please help me to sloving this issues.

My work environment is WIN 7, Excel 2010

Public Sub UserForm_Activate()
'If Weekday(Date, vbSunday) = 1 Then
'EntryDateBeg = Date - 2
'ElseIf Weekday(Date, vbSunday) = 2 Then
'EntryDateBeg = Date - 3
'Else
'EntryDateBeg = Date - 1
'End If
'Me.Calendar1.Value = EntryDateBeg
'Me.Calendar2.Value = Sheets("Home Sheet").Range("AB2").Value
'End Sub

for calendar control we are using above code. but in this line "me.calendar1.value = entrydateBeg " error is comming. the error is "Can't find project or library"

How to rectify this and how to get calendar control in my form.

Thanks,
Santhi.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-prog...rol-issue.html
Thread Closed.