Date Multibox Setting

[#1]

In the attached document I have a speedometer and when you click on it activates tab two.  When I go back to tab one I am trying to figure out how to reset the multibox date back to the most current date in the table.  In this example it would 05/23/2011.

[Anonymous · Accepted solution]

Hi spb,

When you set your OnActivate trigger, set the search expression to =Max(Date) and it should select the max date for you when activating sheet 1 again.

[#3]

Thank you very much Johannes.