i am programming an excel worksheet in which i need a cell to me able to
display to me the current system date. That is anytime i access the file, the
cell should be able to pick the current date as at the day i am accessing it.

please help

Hi mechi

Write an Auo_Open macro that runs when you open the file. Write the
Date/Time in a cell you want to have it.
Example:

Sub Auto_Open()
Range("A1") = Now()
End Sub

Regards
reklamo

"mechi" wrote:

> i am programming an excel worksheet in which i need a cell to me able to
> display to me the current system date. That is anytime i access the file, the
> cell should be able to pick the current date as at the day i am accessing it.
>
> please help
>

with activesheet.range("A1")
.numberformat = "mm/dd/yyyy"
.value = date
end with

now will include the time.

mechi wrote:
>
> i am programming an excel worksheet in which i need a cell to me able to
> display to me the current system date. That is anytime i access the file, the
> cell should be able to pick the current date as at the day i am accessing it.
>
> please help

--

Dave Peterson