Drop Down List from different sheet

[gibbylinks]

Is it possible to have a drop down list using a list from a seperate
spreadsheet

thanks

[gibbylinks]

Found combo box on the forms toolbar, but this has a border around it and the
arrow also the text is a different size when printed !!!!


"gibbylinks" wrote:

> Is it possible to have a drop down list using a list from a seperate
> spreadsheet
>
> thanks
>

[Max]

> "gibbylinks" wrote:
> > Is it possible to have a drop down list using a list from a seperate
> > spreadsheet

Yes, it's possible if you name the list range
(either via the namebox or via clicking Insert > Name > Define)

See Debra Dalgleish's nice coverage at her:
http://www.contextures.com/xlDataVal01.html

Scroll down a bit to the part: 2. Name the List Range
"If you type the items on a worksheet, and name the range, you can refer to
the list from any worksheet in the same workbook ..."
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[gibbylinks]

Thanks Max

Sorted

"Max" wrote:

> > "gibbylinks" wrote:
> > > Is it possible to have a drop down list using a list from a seperate
> > > spreadsheet
>
> Yes, it's possible if you name the list range
> (either via the namebox or via clicking Insert > Name > Define)
>
> See Debra Dalgleish's nice coverage at her:
> http://www.contextures.com/xlDataVal01.html
>
> Scroll down a bit to the part: 2. Name the List Range
> "If you type the items on a worksheet, and name the range, you can refer to
> the list from any worksheet in the same workbook ..."
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---

[Max]

"gibbylinks" wrote:
> Thanks Max
> Sorted

Great to hear that !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---