Forum Discussion
Drop down list "moving" selection when selected in another cell
- Apr 26, 2024
Does the VBA code in the attached file work as intended? If you select a name from a dropdown in a cell in range F5:F24 the code checks if this name is found in range E5:E24. If it is found in E5:E24 then it gets cleared. The corresponding result is returned for a name selected from a dropdown in a cell in range E5:E24. The ranges in the VBA code can be changed according to the actual size of the "zones".
Does the VBA code in the attached file work as intended? If you select a name from a dropdown in a cell in range F5:F24 the code checks if this name is found in range E5:E24. If it is found in E5:E24 then it gets cleared. The corresponding result is returned for a name selected from a dropdown in a cell in range E5:E24. The ranges in the VBA code can be changed according to the actual size of the "zones".
- sophiemarie92Apr 26, 2024Copper ContributorThis is exactly what I was looking for thank you so much!