Users able to select only today's date which then remains a static value

  • I have a spreadsheet to collate the time off requests for my staff for their roster. In one cell they need to select 'Date of Request'. I have a drop down list that only allows them to select today's date as defined by a reference cell with =TODAY().


    Looking around some forums though, it would look like when I check this tomorrow, the date will have updated.


    I want to limit the cell value so that it has to be today's date (so they can't change dates or enter an earlier date to make it look like they were in first) with a static value...


    Any help is greatly appreciated!


    Cheers


    Tom

  • Re: Users able to select only today's date which then remains a static value


    Using the control key and the semi-colon key will give you a static current date.


    Alternatively, you could create a command button and attach this code to the button


    Code
    1. Sub DATEX()
    2. ActiveCell.Value = Date
    3. End Sub