Auto select Max date in list box

[chrismtb]

Hi,

I have a list box with dates in.

As my dashboard publishes daily the list box updates with new dates.

I want my list box to select the most recent date available by default.

I think this should be simple but not sure how to do it!

Thanks

[Taoufiq_Zarra]

since you can't add actions to the lists.
I propose the following scenario:
1- in Sheet properties -> Trigger->OnActivateSheet->Edit Actions

2-Add->Select in Field->
Field: your date
Searching String: =Max(date)

with this the users automatically get the date selected.

[chrismtb · Accepted solution]

I actually ended up putting the event trigger on the Document Open Actions rather than the sheet activate.

Also i had to use =MaxString(MyDate) rather than just Max as this didn't work initially.

Now working perfectly so thanks!