ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I create a Drop Down List in a cell? (https://www.excelbanter.com/excel-programming/299956-how-do-i-create-drop-down-list-cell.html)

Jetheat[_4_]

How do I create a Drop Down List in a cell?
 
I've messed around with right click and "Create List" but just can'
seem to get it right.

I have a column labled "instrument" at the top. In that column, I'
like a drop down list for every row. The drop down list contains
items:


Euro
GBP
JPY
CHF

How do I go about making this list as it's just not happening for me a
the moment?

Thank

--
Message posted from http://www.ExcelForum.com


Frank Kabel

How do I create a Drop Down List in a cell?
 
Hi
see: http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany


I've messed around with right click and "Create List" but just can't
seem to get it right.

I have a column labled "instrument" at the top. In that column, I'd
like a drop down list for every row. The drop down list contains 4
items:


Euro
GBP
JPY
CHF

How do I go about making this list as it's just not happening for me
at the moment?

Thanks


---
Message posted from http://www.ExcelForum.com/



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

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