ExcelBanter - Drop Down List..

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Drop Down List.. (https://www.excelbanter.com/excel-programming/353149-drop-down-list.html)

mseifert_99

Drop Down List..

I want to create a Drop Down List Cell but I dont want ot have to select
a range of cell for the List. I would like to just input the values
myself.. Is there a way to do that.

--
mseifert_99
------------------------------------------------------------------------
mseifert_99's Profile: http://www.excelforum.com/member.php...o&userid=30573
View this thread: http://www.excelforum.com/showthread...hreadid=511751

Bob Phillips[_6_]

Drop Down List..

Yes.

Goto DataValidation
Select List from the Allow dropdown, then just type your values in, comma
separated.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mseifert_99"
wrote in message
...

I want to create a Drop Down List Cell but I dont want ot have to select
a range of cell for the List. I would like to just input the values
myself.. Is there a way to do that.

--
mseifert_99
------------------------------------------------------------------------
mseifert_99's Profile:
http://www.excelforum.com/member.php...o&userid=30573
View this thread: http://www.excelforum.com/showthread...hreadid=511751

mseifert_99[_2_]

Drop Down List..

Boy ! Dont I fill Stupid.. Thanks .

--
mseifert_9
-----------------------------------------------------------------------
mseifert_99's Profile: http://www.excelforum.com/member.php...fo&userid=3057
View this thread: http://www.excelforum.com/showthread.php?threadid=51175

mseifert_99[_3_]

Drop Down List..

mseifert_99[_4_]

Drop Down List..

mseifert_99[_5_]

Drop Down List..

Boy ! Dont I fill Stupid.. Thanks ..

--
mseifert_99
------------------------------------------------------------------------
mseifert_99's Profile: http://www.excelforum.com/member.php...o&userid=30573
View this thread: http://www.excelforum.com/showthread...hreadid=511751

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