About the focus issue of dropdown lists (data validation lists) in Microsoft 365 Excel

Anonymous
2024-08-30T06:14:21.1966667+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?

Figure 1: Correct status

User's image

Figure 2: The status of the error

User's image

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
Microsoft Teams | Microsoft Teams for business | Other
0 comments No comments
{count} vote

2 answers

Sort by: Most helpful
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  2. Anonymous
    2024-09-02T09:03:55.49+00:00

    Is this a bug that Microsoft Office365 updated from old version to 2402?
    If this is a bug, when this problem can be fixed?


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.