Thread: In cell drop down

Hello

I was wondering if their is any way to have a drop down box that will hold
both an account number and account name but only input the account number
into the box. Or if their is another or better way to do this.

Thanks-Mark

Hi
one way:
See:
http://www.contextures.com/excelfiles.html
and search for
Data Validation "Columns"


--
Regards
Frank Kabel
Frankfurt, Germany
"Markitos" <Markitos@discussions.microsoft.com> schrieb im Newsbeitrag
news:B2077496-A21B-4E52-8B2A-E8FBBDF27730@microsoft.com...
> Hello
>
> I was wondering if their is any way to have a drop down box that will hold
> both an account number and account name but only input the account number
> into the box. Or if their is another or better way to do this.
>
> Thanks-Mark

Thanks Frank for that great site. I downloaded the sample file. But I still
didnt get it, Im not good at Codes (macros) BUT I went on the sheet and
selected an item ID AND name and I counldnt get it to change over into just
one of them.

Thanks-
Mark

"Frank Kabel" wrote:

> Hi
> one way:
> See:
> http://www.contextures.com/excelfiles.html
> and search for
> Data Validation "Columns"
>
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
> "Markitos" <Markitos@discussions.microsoft.com> schrieb im Newsbeitrag
> news:B2077496-A21B-4E52-8B2A-E8FBBDF27730@microsoft.com...
> > Hello
> >
> > I was wondering if their is any way to have a drop down box that will hold
> > both an account number and account name but only input the account number
> > into the box. Or if their is another or better way to do this.
> >
> > Thanks-Mark
>
>
>