Using ComboBox Change or Click event with IF or Case statement

[julhs]

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.

 

[Micron]

Where did GetFocus come from? I can't tell if you're asking about code or user actions because I don't think there is anything called GetFocus (unless it was a user defined function - UDF).

If you mean GotFocus then no, they are not the same thing.
Are you trying to use a wild card with * ? Can't do it that way. Would have to use LIKE operator.
If the value is really "Check Entry value" why not just use that? Otherwise,
If Range("D24") LIKE "Check*" Then

 

[julhs]

I got “Get Focus” from your post #8, but I may have miss-interrupted actually what you meant?

AFAIK, Click event code won't fire a combo on a sheet. Does for Access though, which is kinda stupid. Maybe you can use Dropdown as suggested, or GotFocus event, or both if needed.

In the intervening time, I had abandoned using wildcards (*) and had actually resorted to what you have suggested.
It did require a degree of extra coding, but that was fine to get the desired outcome.
At this point I’ve not tried using “Like” but will test it out.
Since I last posted I have been dealing with other aspects of this whole spreadsheet, so only now come back to this query.
Still other bits I need to address before I can properly come back to this.
Many thanks for your input to date.