Data validation dropdown arrow moving

TheJay

Active Member
Joined
Nov 12, 2014
Messages
364
Office Version
  1. 2019
Platform
  1. Windows
Hello there, I've come across a problem with my dropdown list. The arrow moves from the normal place by the side of the data validation list to several cells lower depending on the selection made. Has anyone else come across this before? I need to stop it from happening.

SBqJ7H0.png

y4OrZyT.png
 
Out of interest, what are your thoughts behind this being a fix?
I'm not really certain what is causing the initial issue.
There was no particular theory behind my suggestion but I just tried adding that code line and it seemed to work for the small amount of testing that I did. 😎
 
Upvote 0

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
@TheJay
I Have moved your 'Mark as Solution' tick from post 11 to the post that actually contained the solution as that is the way we want it used. :)
 
Upvote 0
Thank you Peter, momentary stupidity there on my part.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top