Happy new year to all, especially Chandoo with his "upgraded" familly ![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I want to allow the user to select a value in a list for a range of cells, but I want the list to be displayed the following way :
CODE1 - Explanation 1
CODE2 - Explanation 2
...
Codex is the value in the cell.
Is there a way (formula / vb?) to do so ?
Cyril Z.
I want to allow the user to select a value in a list for a range of cells, but I want the list to be displayed the following way :
CODE1 - Explanation 1
CODE2 - Explanation 2
...
Codex is the value in the cell.
Is there a way (formula / vb?) to do so ?
Cyril Z.