Hi,
I am trying to change the ListIndex of a ComboBox(2) based on a value driven from a previous ComboBox(1).
- ComboBox(1) is a customer drop-down list on Sheets("Sheet1")
- Based on ComboBox(1) selection Sheets("Sheet1").Range("F1") is updated with a lookup value
-...