Automatic selection of Date from dropdown list

Hello:

Please refer to attached sheet.

I need to select the date from a dropdown list in Cell A3.

I want to keep the dropdown list but when I come to this sheet, i need today's date
automatically chosen in cell A3.

Please let me know if any questions.

Thank you

Riz

Increase your data validation selection to for example "H200", while keep "ignore empty cells" on.

Then add the workbook open event as follows :

Private Sub Workbook_Open()
If Sheets(1).Range("H65536").End(xlUp).Value <> Date Then Sheets(1).Range("H65536").End(xlUp).Offset(1, 0).Value = Date
Range("A3").Value = Sheets(1).Range("H65536").End(xlUp).Value
End Sub

Works fine

Hi JasferD:

It does not work for me.
Can you please upload the excel file with the code.

Please let me know if any questions.

Thank you

Riz