Excel Dates

Delore · #1 (**permalink**) 05-12-11, 19:25

I have created a form with an automatic date function. When form is opened the function Today() auto enters the date in the top of the form. I want to lock this date so it does not change when the form is opened on subsequent dates. I cannot find a solution using the help function. Can anyone help
Thanks

Gene

Colin Legg · #2 (**permalink**) 05-13-11, 11:10

Hi Gene

TODAY() is volatile so it will continue to recalculate on subsequent dates. Your only option is to put the date in the cell as a constant.

Nielsje · #3 (**permalink**) 07-20-11, 07:16

Or simply use an If statement to check this.

Code:

If Range("A1").Value = "" Then Range("A1").Value = Date

On subsequent dates, the date in cell A1 will not change, because cell A1 is not empty anymore.

(I used the Date function in VBA to return the Date without the time).

Internet Services

Web Development

Digital Marketing

Consumer Tech