Data validation list - update selection

DMT

New Member
Joined
Jan 21, 2004
Messages
28
My problem is as follows:

I have a cell with a data validation list. The list range changes based on what is entered in an "input cell." The range is dynamic. However, if someone enters a value in the "input cell" and chooses from the dropdown list and then changes their mind and enters a new value in the "input cell", the old selection from the first entry remains in the dropdown list cell. I would like this selection to go away or change automatically based on the input cell. This would avoid errors.

This automatic updating that I am talking about is similar to how the combo box works from the Forms menu. Ideally, I would like the look and fell of the data validation list, but the auto-updating of the combo box.

Is this possible? Thanks.
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Forum statistics

Threads
1,186,326
Messages
5,957,228
Members
438,294
Latest member
Soikeo79

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
Top