pick from list

[johnjohnstone]

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.

 

[Norman Jones]

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

 

[tony h]

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

Cheers

 

[Norman Jones]

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

==>

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

 

[Guest]

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

 

[tony h]

Well done Tom for reading the question properly.

: