Chau Nguyen
New Member
Dear all,
I ran into this annoying bugs when using VBA to change the value of a cell that has Data Validation (DVL for short) on it. Please see the picture below.
I use VBA to change the value of these cell. After the code ran several times these residual, empty DVL dropdown box started appearing.
I only use the simple statement Range("...").Value = "..."
It does not affect calculation and stuff but its annoying to the users because they cannot select the cell under the empty DVL dropdown using the mouse. They have to move the cursor by keyboard.
Any solutions are more than welcome.
I ran into this annoying bugs when using VBA to change the value of a cell that has Data Validation (DVL for short) on it. Please see the picture below.
I use VBA to change the value of these cell. After the code ran several times these residual, empty DVL dropdown box started appearing.
I only use the simple statement Range("...").Value = "..."
It does not affect calculation and stuff but its annoying to the users because they cannot select the cell under the empty DVL dropdown using the mouse. They have to move the cursor by keyboard.
Any solutions are more than welcome.
