Please, can someone explain this behavior?
I have a userform with 2 ComboBoxes. The 1st one is populated from a range of cells which contains 4-digit numbers (cells formatted as text) and has the AutoTab property set to TRUE and MaxLength set to 4. Both ComboBoxes have TabStop property set to TRUE. When I type in this 1st ComboBox a number, it tabs automatically as expected to the 2nd ComboBox, EXCEPT if the number ends in 0 and exists in the source. This behavior happens in the following Excel versions:
Office365Pro 16.0.11929.20436 32bit
2019Pro 16.0.12527.20260 32bit
However, in version Excel2010 14.0.7237.5000 32bit it behaves always as expected. Why is that so?