Macro or function to capture the system date

[vijanand1279]

Hi,

Please assist for Date entered in column B must auto populate current date immediately after the name is entered in column A
The date must not change to next date, because I tried using today function and the date was changing when the file was opened next day.

I am looking for a function or macro for this.

Vijay

[jolivanes]

Something like this?
Worksheet Change Event is in the sheet module