having a bad moment with my Excel because the drop-down list of Data Validation in one specific spreadsheet of my workbook (DV works fine in other sheets though) is not scrolling at all.
For the said issue, I have done the following elimination methods to attempt to find out the root cause:
- disabled all sheet-specific event procedures in VBA.
- checked/unchecked the 'Zoomo on roll with IntelliMouse' in the advanced setting as per some online recommended remedy
- re-directed the source in Data Validation to a shorter list of references to check if the current list (of 140 choices) is causing the problem of the static drop-down menu bar
- checked if there are overlapping objects that somehow may be causing the issue.
Having done all the above mentioned, I cannot seem to resolve the issue in hand, although i can use the up/down arrow keys on my keyboard to navigate the choices within the drop-down menu.
so frustrating...