Compile error - Method or data member not found

[Pauljj]

Oddly I am only just getting this error when it has previously worked without a problem, it errors out on Me.Calendar1.Value = Date ??? Any ideas as to why this would now not work?


Private Sub Calendar1_Click()

ActiveCell = Calendar1.Value

ActiveCell.NumberFormat = "dd/mm/yyyy"

End Sub

-----------------------------------------------

Private Sub UserForm_Activate()

Me.Calendar1.Value = Date

End Sub

 

[MrKowz]

What is Calendar1 in your UserForm?

 

[Pauljj]

Sorry, I am not sure I understand what you mean ?

 

[Richard Schollar]

If you go into Tools>References in the VBE do you have anything listed as MISSING? If so, uncheck them and try again

 

[Pauljj]

I'm so dim ...calandar control was missing..the obvious thing I should have checked


Apologies for wasting your time and thank you