Hi

I need a list to appear eg (A1:A12) when a cell is clicked. Then when a
list item is clicked i need it to be entered into the cell. Help much
appreciated

Hi Suril,

This facility is offered by rhe built in Data Validation feature.

See Debra Dalgleish's web page on Data Validation which provides a tutorialt
with step by step instructions ilustrated wit numerous informative
screenshots.

---
Regards,
Norman



"Sunil Patel" wrote in message
...
Hi

I need a list to appear eg (A1:A12) when a cell is clicked. Then when a
list item is clicked i need it to be entered into the cell. Help much
appreciated

Hi Suril,

Let me try that again and iclude the link as well!

This facility is offered by the built in Data Validation feature.

See Debra Dalgleish's web page on Data Validation which provides a tutorial
with step by step instructions illustrated with numerous informative screen
shots:

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


---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Suril,

This facility is offered by rhe built in Data Validation feature.

See Debra Dalgleish's web page on Data Validation which provides a
tutorialt with step by step instructions ilustrated wit numerous
informative screenshots.

---
Regards,
Norman



"Sunil Patel" wrote in message
...
Hi

I need a list to appear eg (A1:A12) when a cell is clicked. Then when a
list item is clicked i need it to be entered into the cell. Help much
appreciated

I might want to look at the List option of the Data, Validation feature.

--
Jim
"Sunil Patel" wrote in message
...
| Hi
|
| I need a list to appear eg (A1:A12) when a cell is clicked. Then when a
| list item is clicked i need it to be entered into the cell. Help much
| appreciated
|
|