problem use Addin

[Abhijeet]

Option Explicit

' ==============================================================
' The Pop-up Calendar Add-In for Excel 2007/2010
' Devised and coded by Martin Green
' View the tutorial at http://www.fontstuff.com/vba/vbatut07.htm
' Contact: martin@fontstuff.com
' ==============================================================

Private Sub cmdClose_Click()
Unload Me
End Sub

Private Sub MonthView1_DateClick(ByVal DateClicked As Date)
On Error Resume Next
Dim cell As Object
For Each cell In Selection.Cells
cell.Value = DateClicked
Next cell
Unload Me
End Sub

Private Sub UserForm_Initialize()
If IsDate(ActiveCell.Value) Then
Me.MonthView1.Value = ActiveCell.Value
End If
End Sub

When I use this code in AddIn then I have problem in this code that part is Bold.Please tell me why

 

[Hui]

Did you ask the Author, "martin@fontstuff.com" ?

 

[Abhijeet]

Can u please give other macro for Date picker in excel then

 

[SirJB7]

@Hui
Hi!
Don't you think it'd be a good idea if r1c1 renames the website from www.chandoo.org to www.macrohypermarket.org?
Regards!

 

[Hui]

Abhijeet
Have you tried using the Search Box, Top right of this and every screen at Chandoo.org

 

[SirJB7]

@Hui
Hi, buddy!
I firmly believe he did... the problem is with the answer he got: "give me macro".
Regards!