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?

Jiang Ya I 10 Reputation points
2024-09-09T00:46:37.7266667+00:00

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?

OK2NG

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?

スクリーンショット 2024-09-04 172357

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,180 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,734 questions
0 comments No comments
{count} vote

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.