Hi

I have a calendar control which populates cells X$3$ to $X$2580. So If I
select cell X$5$ the calendar pops up and I select a date and this is then
entered into cell X5. What I also want to do is put Now() into cell $W$5
I have never used VBA in excel before only in access, so dont know about
active cells

any help greatly appreciated

Thanks

Richard