We have several template files that require a date in cell A1 of Sheet1. Is it possible to have VBA include the date based on the computer clock but only one time and that is automatically when the file is opened? The format would be mmmm d, yyyy.
Some videos you may like
Which lookup functions find a value equal or greater than the lookup value?
If you want the date to appear EVERYTIME you open the file, you can simple use ---> =today()
and you can set the date format from FORMAT CELL option of that cell.... That way the date will change everyday, and whenever you open the file, it will show you the CURRENT date
And if you want the cell to show to update the date only ONCE that is the FIRST time the file was opened, and NEVER again. You can simply select the cell and press- -----> "CTRL ;" (Hold CTRL key and press the semicolon symbol)
There is a VBA for everything my friend, you just need to know.
But if you want VBA to do it EVERYTIME, then you just rather use the =today() in that cell.
And if you want VBA to do it ONCE only, you will need to run it once by pressing shortkey or a button that you assign that VBA macro to. in either case you are pressing something (2 keys to generate the macro, or the button to generate the macro) you might just click "ctrl and ;" after selecting that cell.
I am definetly missing something here, otherwise "ctrl ;" should hav solved your problem. Why do you want a VBA for it? even in the most ideal situation, using VBA will only save you ONE keystroke per worksheet, thts it.