This can be done at design time, because I may have 10, 20 or even 100 cells
need this drop down list, how do I do that programmatically when I click the
cell in a particular column, for example, from C10 to C100, if the user
click these cells, the dropdownlist will appear ?

"mangesh_yadav"
wrote in message
news:mangesh_yadav.1qlzmg_1118739936.1606@excelfor um-nospam.com...

One way:
Select cell, go to Data Validation. select list and then the source
for the list

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=378908