Fix a (Today) Date in Excel

Fix a (Today) Date in Excel I have a file with a VB macro that puts a TODAY() formula in a cell when I click a button. The formula is volatile and updates every time the sheet is calculated. Instead, I would like to lock the value so that it only shows the date on which the macro was executed. So, if I open the file tomorrow, it will be the same value. How can I do this?
Asked by: Guest \| Views: 242

Total answers/comments: 2

Comments display order:

Guest [Entry]

"Use the value property of the cell:

TheCell.Value = Date

Date = Today"

Guest [Entry]

"Quick way of doing this -

Select the cell and press Ctrl + ;

Another trick -
Under the same conditions, if you want to insert the current time in HH: MM format:

Press Ctrl + : in the cell.

(FOR MAC: cmd + ;)"