custom list

A

Anthony

hi,
have set up a custom list >tools>options>custom lists>import list from cells.
how do i now insert this list in a column on a spreadsheet?
any help would be great
thanks
Anthony
 
B

Bob Phillips

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

--

HTH

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

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

Bob Phillips

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

Dave Peterson

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
 
Top