Dear colleagues,
The issue I have specifically occurs when I double click on a cell with a data validation list.
Situation:
- I have a cell containing a data validation list > works fine
- I should be able to select a product from the list or type in free text > works fine
- I should be able to edit the free text > doesnt work > the text disappears.
My findings are:
- Clicking (1x) on the cell with the data validation list shows the "busy" mouse cursor briefly.
- Double clicking on the cell with the data validation list also shows the "busy" mouse cursor running and receive the message Microsoft Excel has stopped working
- Im not able to edit the text in the cell (which is normally possible if you double click the cell)
- Excluding the macros removes the issue only partially (Excel doesnt stopped working anymore) but it is still not possible to edit the text in the cell because the text just disappears when double clicked on the cell. Pressing esc then shows the text again
(=logic). When Enter is pressed, the text is then gone.
Can anyone please help me with this?