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.
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,123,400
Messages
5,601,462
Members
414,451
Latest member
jrose7

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