ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Newbie-need menu of names (https://www.excelbanter.com/excel-programming/333210-newbie-need-menu-names.html)

Sunil Patel

Newbie-need menu of names
 
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



Norman Jones

Newbie-need menu of names
 
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




Norman Jones

Newbie-need menu of names
 
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






Jim Rech

Newbie-need menu of names
 
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
|
|




All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com