Why does the VBA Case Select statement always default to "Case Else" and ignore matching cases?

edit

The VBA Case Select statement does not always default to "Case Else" and ignore matching cases. If a matching case is found, then the code in that particular case block will be executed.

However, if none of the cases match the expression being evaluated, then the code in the "Case Else" block will be executed. This is because "Case Else" is used as a catch-all case for any expressions that do not match the previous cases.

It is important to ensure that all possible cases are accounted for in the select statement to avoid unintentional execution of code in the "Case Else" block.