talytech
09-26-2008, 10:21 AM
Is there a way to have a cell auto populated when the user opens the worksheet? The following code did not work for me.
Private Sub Worksheet_Activate()
Worksheets("Multiple Rooms").Range("I2").Value = Date
End Sub
Basically, I want the current date to automatically be in the cell I2 when the user opens the form.
Private Sub Worksheet_Activate()
Worksheets("Multiple Rooms").Range("I2").Value = Date
End Sub
Basically, I want the current date to automatically be in the cell I2 when the user opens the form.