Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
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.
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!