From: JM on
I need a drop down that will show a code and a description of that code, but
after I select it I only want the code visible.
From: Gord Dibben on
All in the same cell?

Can probably do this with Data Validation dropdown and some event code.

Post some examples of code and description.


Gord Dibben MS Excel MVP

On Tue, 12 Jan 2010 12:16:01 -0800, JM <JM(a)discussions.microsoft.com> wrote:

>I need a drop down that will show a code and a description of that code, but
>after I select it I only want the code visible.