Hello -

I've found a few posts / ideas that come close (but can't stop my spreadsheet from crashing when activating?)

I have a primitive search function at the top of my sheet that will give a search-specific dropdown in cells O2 and O4 based on codes or keywords inputted into K2 and K4 respectively.

I would like these 4 x cells' contents to reset/blank (i.e. 'clear' not delete) every 2 minutes (but not the dropdown functions themselves for O2 and O4) (please note, they are merged cells at the moment and some of the VBA doesn't like that, if they need un-merging, so be it!) so users can keep using it without clearing the cells with a physical delete.

Alternatively, if its difficult to do based on timing, if the main body of the sheet (A8: AO200) is accessed, then it then blanks, this would also be OK as an alternative?

Any help would be very appreciated

Thanks