Change the list contents in a cell, when changing the contents in another cell.

Hans Gatu

New Member
Joined
Feb 18, 2014
Messages
5
The user fill in these cells:
D5, D6, D7, D9 and D10.
Other cells are locked, so with Tab, Enter or Arrows, you step through these cells.
D5 and D7 are pull down lists with 10 different alternatives each.
Normally you start with selecting someting in the D5 list.
Depending on what you select in D5, the content list of D7 shall alter beween two different lists.
Those two lists are the contents of AM3:AM12 or AN3:AN12.

Basically it works now, but if you have a value (a word) in the D5 list, that correspond to the AM3:AM12 list in D7,
then you see a sertain value in D7 (lets say that you see the value of the AM6 cell).
If you now select another value (another word) in the D5 list, that now correspond to the AN3:AN12 list in D7,
then you instantly should see a value in D7, that correspond to the AN3:AN12 list (i.e. you should see the value of the AN6 cell),
but now the old value (the AM6 value) is still in the cell, until you actually step to D7 and pull down the list and select the new value.

I was thinking that the OnKey function could work, when you leave the D5 cell with any of the keys:
Application.OnKey "{ENTER}"
Application.OnKey "~"
Application.OnKey "{DOWN}"
Application.OnKey "{UP}"
to activate the shift of lists in D7 and also shift the value in D7 that you see, before you actually get to the D7 cell.
But I havn't got it working.


/ Hans Gatu
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,223,898
Messages
6,175,274
Members
452,628
Latest member
dd2

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