Attach custom list to a cell
 

I have created a custom list. Now I want to be able to enter a text into a cell from that list
How can I do that?

Attach custom list to a cell
 

Look at Data Validation. See Debra's site for details at
http://www.contextures.com/xlDataVal01.html

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark" wrote in message
...
I have created a custom list. Now I want to be able to enter a text into a
cell from that list.
How can I do that?

Attach custom list to a cell
 

Mark

Just to clarify.

Custom Lists are not used in the manner you describe. See Bob's answer for
how to do the Data Validation list.

Custom Lists are used to create a list of data in adjacent cells as you
drag/copy down or across.

Example.....the days of the week are a Custom List, the alphabet is a custom
list.

George, Gord, Bob, Mark, Bill, John can be a custom list you add through
ToolsOptionsCustom List.

Enter George in A1 then drag/copy down to get the other names in the list
entered in cells below.

There is a third "list type" which is "pick from list".

If you have data in a column or row and you right-click on a cell in that
column and select "pick from list" you will get a list of unique items to pick
from based on the data in the column.

Gord Dibben Excel MVP

On Sat, 3 Apr 2004 00:12:18 +0100, "Bob Phillips"
wrote:

Look at Data Validation. See Debra's site for details at
http://www.contextures.com/xlDataVal01.html

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark" wrote in message
...
I have created a custom list. Now I want to be able to enter a text into a
cell from that list.
How can I do that?

Attach custom list to a cell
 

On Fri, 02 Apr 2004 15:38:53 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

If you have data in a column or row

Make that just column.

Gord

Attach custom list to a cell
 

If later on I need to add more imtes into a list how would I do that?

Attach custom list to a cell
 

Hi
you may use a dynamic range for this as data source. e.g. on the same
site see
http://www.contextures.com/DataValDateRange.xls

--
Regards
Frank Kabel
Frankfurt, Germany

"Mark" schrieb im Newsbeitrag
...
If later on I need to add more imtes into a list how would I do that?

Attach custom list to a cell
 

Not sure how that works. Is there any other way to update named list

Attach custom list to a cell
 

Hi
if you want a dynamic list this is the easiest solution (of course you
can define your initial list larger than required)

--
Regards
Frank Kabel
Frankfurt, Germany

"Mark" schrieb im Newsbeitrag
...
Not sure how that works. Is there any other way to update named list?