custom list
 

hi,
have set up a custom list toolsoptionscustom listsimport list from cells.
how do i now insert this list in a column on a spreadsheet?
any help would be great
thanks
Anthony

Just enter the first two value into 2 cells, and drag and copy.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anthony" wrote in message
...
hi,
have set up a custom list toolsoptionscustom listsimport list from
cells.
how do i now insert this list in a column on a spreadsheet?
any help would be great
thanks
Anthony

thanks Bob but am looking to use a "pick from drop down list". what i mean is
instead of entering the value i would select the cell and use the drop down
button which would appear beside that cell to pick from the list i have
created in custom lists.


"Bob Phillips" wrote:

Just enter the first two value into 2 cells, and drag and copy.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anthony" wrote in message
...
hi,
have set up a custom list toolsoptionscustom listsimport list from
cells.
how do i now insert this list in a column on a spreadsheet?
any help would be great
thanks
Anthony

Anthony,

Then I don't think there is much use in creating it as a custom list.

Create it as a range on a worksheet as I suggested earlier, name that range,
then use that named range in you DV cell(s).

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anthony" wrote in message
...
thanks Bob but am looking to use a "pick from drop down list". what i mean
is
instead of entering the value i would select the cell and use the drop
down
button which would appear beside that cell to pick from the list i have
created in custom lists.


"Bob Phillips" wrote:

Just enter the first two value into 2 cells, and drag and copy.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anthony" wrote in message
...
hi,
have set up a custom list toolsoptionscustom listsimport list from
cells.
how do i now insert this list in a column on a spreadsheet?
any help would be great
thanks
Anthony

I think you'd need code:

Take a look at application.getcustomlistcontents in the help and you'll see that
you can acces it directly.

For example:

Option Explicit
Sub testme()
Dim listArray As Variant
Dim iCol As Long
Dim wks As Worksheet

Set wks = Worksheets.Add

For iCol = 1 To Application.CustomListCount
listArray = Application.GetCustomListContents(iCol)
wks.Cells(1, iCol).Resize(UBound(listArray) _
- LBound(listArray) + 1, 1).Value _
= Application.Transpose(listArray)
Next iCol

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Anthony wrote:

hi,
have set up a custom list toolsoptionscustom listsimport list from cells.
how do i now insert this list in a column on a spreadsheet?
any help would be great
thanks
Anthony

--

Dave Peterson