Data validation drop list not highlighting previously entered time value

Hi all,

Please refer to the attached file.

I have a cell with a data validation rule set based on a list of predefined time values. When a value is already entered into that cell and then I re-open the list, I expect that the droplist will highlight and be focused on that previously entered value. Instead, it is always focused back on the first entry in the list. This is very annoying when I want to adjust the selection up or down by one interval.

The normal behaviour, as shown in the droplist based on string values, is that the droplist will highlight and focus on the previous entry.

I have played around with potential issues such as time values not matching because of rounding of the underlying number. I have tried forcing the time values in the list to be rounded to 6 places to ensure a match, but this hasn't helped.

I am using Windows Excel 365 for enterprise. Build version 2307.

Any advice much appreciated.

Thanks Jeff. Can't use the forms idea as the cell in question appears on many rows in a worksheet.

That's it Ali! It took a bit of reworking but that has sorted the problem. Many thanks!