I have a list box object (LB1) with 2 values. If the user selects the second value in the LB1 I want to fire an action/trigger that will select a specific item in another list box object (LB2) on the same sheet. And if the user selects the first value on LB1 it should clear the selections made on LB2. I would like to achieve this via the sheet properties > object > action but cant seem to conditionally fire the action based on the selection made in the LB1. [Note: I don't want to clear all selections on other objects on the sheet, just the one selected for LB2].
