how to add a combolist drop down to each row

[sumesh56]

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

I tried this on first time.why on
D5 the content is not clear? what should be the ideal procedure?for m
present purpose what kind of listcontrol should i select from the activ
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 ro
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 a
qualities. is it necessary to keep this somewhere in the worksheet?

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

kindly explain in detail. thank

+-------------------------------------------------------------------
|Filename: combolist dropdown.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=967
+-------------------------------------------------------------------

 

[Claus Busch]

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 D312.

select D312 => Data => Data Validation => List


Regards
Claus B.

 

[sumesh56]

Hi,

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

select D312 => Data => Data Validation => List


Regards
Claus B.

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

+-------------------------------------------------------------------
+-------------------------------------------------------------------