Hi,

I need to get the value present in the clicked cell into another cell..
like suppose that in the below calendar

June 2011
S M T W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30


if clicked on day 15, then the value should be displayed in another cell like in D6, in the same way if clicked on day 25 then the value 25 should be displayed in D6, i mean on what ever value we click, it should be displayed in D6. If the solution for this problem is to have a macro is also fine...

Please help me with this... Thanks in advance...

if you build your calendar in cells A2 to G7 for example then add this code to the selection change event for that sheet it will show the clicked value in A1

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row >= 3 And Target.Row <= 7 Then
If Target.Column >= 1 And Target.Column <= 7 Then
Range("A1").Value = Target.Value
End If
End If
End Sub