Home » Questions » Computers [ Ask a new question ]

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: 39
Total answers/comments: 2
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 + ;)"