pick from list

I would like to know how to establish the list that can be picked
from.. If I "right click" on a cell I get the option to "pick from a
list" but nowhere can I find out how to make that list.

This is a worksheet issue not a programming issue. Go to Data ... validation ... list ... source put in the range that contains the list

Cheers

Hi John,

Look at Excel'd Data Validation feature:

Data | Validation.

Debra dalgleidh has a n excellent tutorial ob Data Validation at:

http://www.contextures.com/xlDataVal01.html


---
Regards,
Norman



<johnjohnstone@onetel.com> wrote in message
news:1148389135.161585.210350@g10g2000cwb.googlegroups.com...
>I would like to know how to establish the list that can be picked
> from.. If I "right click" on a cell I get the option to "pick from a
> list" but nowhere can I find out how to make that list.
>

> Debra dalgleidh has a n excellent tutorial ob Data Validation at:

==>

Debra Dalgleish has a n excellent tutorial on Data Validation at:

---
Regards,
Norman

the list is generated by Excel from contiguous data immediatly preceding that
cell in the same column.


in A1 put in ABC
in A2 put in EFG
select A3, then right click and select pick from list (or pick from dropdown
list).
--
Regards,
Tom Ogilvy


"johnjohnstone@onetel.com" wrote:

> I would like to know how to establish the list that can be picked
> from.. If I "right click" on a cell I get the option to "pick from a
> list" but nowhere can I find out how to make that list.
>
>

Well done Tom for reading the question properly.