faulkneralder
New Member
- Joined
- Jul 5, 2007
- Messages
- 9
Hello,
I have set up a data validation List cell with a series of list values that changes depending on the value typed in another cell. The user can then select from that generated list and the value is shown in the data validation cell. The setup is like this:
Cell B4 = cell that the user types some freeformat text in
Cell B6 = data validation cell refering to list
Cells B7 to B100 is the list
The list in B7:B100 changes depending on what the user types in B4. So the user could type "soft" in B4 and the list would show all values that have the text "soft" in them. The user then goes to B6 to select the actual entry from the list they want.
What I want to do is after this is done, if the user then deletes B4 or starts to type something new, not only does the B7:B100 list change (which it does ok) but also the value that was previously selected in B6 is erased, or at least is reset automatically to the top value of the B7:B100 list (which is "(Select the actual value from this list)"). Unfortunately although the list itself changes when B4 is re-types, B6 continues to show the old selected value until a new selection is made.
Is there a simple way I can reset B6 automatically when B4 is changed?
Thanks, Peter
I have set up a data validation List cell with a series of list values that changes depending on the value typed in another cell. The user can then select from that generated list and the value is shown in the data validation cell. The setup is like this:
Cell B4 = cell that the user types some freeformat text in
Cell B6 = data validation cell refering to list
Cells B7 to B100 is the list
The list in B7:B100 changes depending on what the user types in B4. So the user could type "soft" in B4 and the list would show all values that have the text "soft" in them. The user then goes to B6 to select the actual entry from the list they want.
What I want to do is after this is done, if the user then deletes B4 or starts to type something new, not only does the B7:B100 list change (which it does ok) but also the value that was previously selected in B6 is erased, or at least is reset automatically to the top value of the B7:B100 list (which is "(Select the actual value from this list)"). Unfortunately although the list itself changes when B4 is re-types, B6 continues to show the old selected value until a new selection is made.
Is there a simple way I can reset B6 automatically when B4 is changed?
Thanks, Peter