Drop Down List from different sheet
 

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

thanks

Drop Down List from different sheet
 

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

Drop Down List from different sheet
 

"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
---

Drop Down List from different sheet
 

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
---

Drop Down List from different sheet
 

"gibbylinks" wrote:
Thanks Max
Sorted

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