
Is this a bug that Microsoft Office365 updated from old version to 2402?
If this is a bug, when this problem can be fixed?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
Figure 2: The status of the error
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
Is this a bug that Microsoft Office365 updated from old version to 2402?
If this is a bug, when this problem can be fixed?