Anyone Know How???

[stapleton2308]

I've been using data/validation/list to use as a drop down bar, not sure if this is the right way, but anyway. As i've got loads of entrys in it, it takes me ages to find the particular one! Correct me if im wrong, but isn't there a way where you can type the first letter, ie R, then it would drop down to the first one which begins with R (the list would be in alphabetical order). then as you type more letters it narrows it down to the one you want??? If this is the case how is it possible, i've see those combo box thingies (bare with me im fairly new to excel), but is that quite in depth to do this or not???

Would be gratful if someone can help!!!

[Norman Jones]

Hi Stapleton,

See Debra Dalgleish at:

http://www.contextures.com/xlDataVal10.html

and

http://www.contextures.com/xlDataVal11.html


---
Regards,
Norman


"stapleton2308" <[email protected]>
wrote in message
news:[email protected]...
>
> I've been using data/validation/list to use as a drop down bar, not sure
> if this is the right way, but anyway. As i've got loads of entrys in it,
> it takes me ages to find the particular one! Correct me if im wrong, but
> isn't there a way where you can type the first letter, ie R, then it
> would drop down to the first one which begins with R (the list would be
> in alphabetical order). then as you type more letters it narrows it down
> to the one you want??? If this is the case how is it possible, i've see
> those combo box thingies (bare with me im fairly new to excel), but is
> that quite in depth to do this or not???
>
> Would be gratful if someone can help!!!
>
>
> --
> stapleton2308
> ------------------------------------------------------------------------
> stapleton2308's Profile:
> http://www.excelforum.com/member.php...o&userid=30878
> View this thread: http://www.excelforum.com/showthread...hreadid=505595
>

[stapleton2308]

Hi Stapleton,

See Debra Dalgleish at:

http://www.contextures.com/xlDataVal10.html

and

http://www.contextures.com/xlDataVal11.html


---
Regards,
Norman


"stapleton2308" <[email protected]>
wrote in message
news:[email protected]...
>
> I've been using data/validation/list to use as a drop down bar, not sure
> if this is the right way, but anyway. As i've got loads of entrys in it,
> it takes me ages to find the particular one! Correct me if im wrong, but
> isn't there a way where you can type the first letter, ie R, then it
> would drop down to the first one which begins with R (the list would be
> in alphabetical order). then as you type more letters it narrows it down
> to the one you want??? If this is the case how is it possible, i've see
> those combo box thingies (bare with me im fairly new to excel), but is
> that quite in depth to do this or not???
>
> Would be gratful if someone can help!!!
>
>
> --
> stapleton2308
> ------------------------------------------------------------------------
> stapleton2308's Profile:
> http://www.excelforum.com/member.php...o&userid=30878
> View this thread: http://www.excelforum.com/showthread...hreadid=505595
>

thanks mate, had a look at it, but is there anyway so it's got nothing to do with the validation cells, and it picks the list from somewhere else?

[Peo Sjoblom]

Not by using validation, you can use a combobox and validation

http://www.contextures.com/xlDataVal11.html

--
Regards,

Peo Sjoblom

Portland, Oregon




"stapleton2308" <[email protected]>
wrote in message
news:[email protected]...
>
> I've been using data/validation/list to use as a drop down bar, not sure
> if this is the right way, but anyway. As i've got loads of entrys in it,
> it takes me ages to find the particular one! Correct me if im wrong, but
> isn't there a way where you can type the first letter, ie R, then it
> would drop down to the first one which begins with R (the list would be
> in alphabetical order). then as you type more letters it narrows it down
> to the one you want??? If this is the case how is it possible, i've see
> those combo box thingies (bare with me im fairly new to excel), but is
> that quite in depth to do this or not???
>
> Would be gratful if someone can help!!!
>
>
> --
> stapleton2308
> ------------------------------------------------------------------------
> stapleton2308's Profile:
> http://www.excelforum.com/member.php...o&userid=30878
> View this thread: http://www.excelforum.com/showthread...hreadid=505595
>

[stapleton2308]

thanks mate, had a look at it, but is there anyway so it's got nothing to do with the validation cells, and it picks the list from somewhere else?

[stapleton2308]

thanks mate, had a look at it, but is there anyway so it's got nothing to do with the validation cells, and it picks the list from somewhere else?

ighghkj gigbnk,m nkbn