Yet again I can’t compile the syntax to get the desired outcome.
What I am trying to achieve is;
If ComboBox20 is Changed or Clicked, EITHER D22 or E22 will be selected DEPENDENT on whether D22 is greater than "", or E22 is greater than "".
Note; D22 and E22 will NEVER BOTH be greater than "", it can only be one or the other.
To summerise;
If ComboBox20 is Changed or Clicked and D22 is greater than "", then D22 is selected
Or
If ComboBox20 is Changed or Clicked and E22 is greater than "", then E22 is selected
I've tried various different approches but all have failed.
What I am trying to achieve is;
If ComboBox20 is Changed or Clicked, EITHER D22 or E22 will be selected DEPENDENT on whether D22 is greater than "", or E22 is greater than "".
Note; D22 and E22 will NEVER BOTH be greater than "", it can only be one or the other.
To summerise;
If ComboBox20 is Changed or Clicked and D22 is greater than "", then D22 is selected
Or
If ComboBox20 is Changed or Clicked and E22 is greater than "", then E22 is selected
I've tried various different approches but all have failed.