Thread: Display of last date used, operator, etc

I am working on an Excel spreadsheet and wanted to know if there is a function that will automatically display on the worksheet the date, time and name of last operator that used or updated the spreadsheet.

Also, are there are safeguards that can be put into place such as determining the wrong type, wrong sequence of entries, wrong data range, and wrong format of numbers entered?

Thank you.

Meg Wenstrand

Hello Meg,

The answers of course are 'Yes'

The standard function =NOW() will give you the Date and Time if you format the cell accordingly. The VBA instruction Application.User will give you the name of the current user (assuming of course that they've entered their name in the Excel Preferences section).

As to the error checking, then you'd need to attach the workbook with examples and notes saying what you're prepared to allow, in order for us to advise further.

Rgds