I don't think I am understanding how VBA handles the passing of objects
and stuff when a button is pressed.
Basically, I have a calender control with the name calendar1 and when I
press the command button I want to put the date into a cell. So the
code I have so far:
Code:
--------------------
Private Sub CommandButton1_Click(Calendar1 As Object)
Range("A1") = Calendar1.Value
End Sub
--------------------
But I get the Compile error:
Procedure declaration does not match description of event or procedure
having the same name.
Can someone explain how VBA handles the sending of objects into subs?
--
FCC
------------------------------------------------------------------------
FCC's Profile:
http://www.excelforum.com/member.php...o&userid=35888
View this thread:
http://www.excelforum.com/showthread...hreadid=557644