How to solve the problem that the cursor in the drop-down list in a cell cannot focus on the option that matches the value entered in the cell,after Microsoft 365 is upgraded to 2402?
How to solve the problem that the cursor in the drop-down list in a cell cannot focus on the option that matches the value entered in the cell,after Microsoft 365 is upgraded to 2402?
The details are as follows
In the Excel VBA project, a drop-down list of cells is implemented using Selection.Validation, and when the user clicks on this drop-down list, the cursor in the drop-down list focuses on the options that are consistent with the values entered in the cell, as shown in Figure 1 below.
Figure 1 status can be displayed normally under Office 2019, Microsoft 365 old version (Version: 2308 Build: 16.0.16731.20496) and other versions, but after Microsoft 365 is upgraded to (Version: 2402 Build: 16.0.17328.20346), clicking the drop-down list of cells shows the wrong status in Figure 2, That is, the cursor of the drop-down list cannot focus on the item with the same value as the one in the cell.
What is the cause of this phenomenon and is there a solution to it?
Supplementary Explanation :
We have identified the code that caused the above issue: please refer to "1" in the following figure, which is caused by the handling of "Application. ScreenUpdating=False". The screen did not refresh in a timely manner, resulting in abnormal display of the dropdown list.
After I changed the code at "1" in the following image to "Application. ScreenUpdating=True", the dropdown list displayed normally.
Due to the absence of display exceptions for dropdown lists on Microsoft 365 (Version 2308), I would like to confirm if there may be compatibility issues between Microsoft 365 (Version 2402) and VBA?