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
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