how to add a combolist drop down to each row
 

i want to get a combolist dropdown menu against each name of students.i have a list of qualities in the dropdown menu. on selection it should display in col D3:D12.

I tried this on first time.why on
D5 the content is not clear? what should be the ideal procedure?for my present purpose what kind of listcontrol should i select from the active x group?why the selected item is not displaying clearly.
what is the method to copy paste the box which i create on the first row to other rows? in this example i have done it seperately for each row. went to design mode. inserted=activex control- etc each time .

I have listed some qulities in G3:G9. this range has been named as qualities. is it necessary to keep this somewhere in the worksheet?

in the design mode-properties window, link range and linked cells- are these fields to be filled manually or is there any way to select by excel.

kindly explain in detail. thanks

how to add a combolist drop down to each row
 

Hi,

Am Thu, 3 Apr 2014 16:42:53 +0100 schrieb sumesh56:

i want to get a combolist dropdown menu against each name of students.i
have a list of qualities in the dropdown menu. on selection it should
display in col D3:D12.

select D3:D12 = Data = Data Validation = List


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Professional

Claus B,
thanks for the direction. have a nice day.