how to add a combolist drop down to each row


S

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 D3:D12.

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
+-------------------------------------------------------------------
 
Ad

Advertisements

C

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 D3:D12.
select D3:D12 => Data => Data Validation => List


Regards
Claus B.
 
Ad

Advertisements

S

sumesh56

Claus said:
Hi,

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

select D3:D12 => Data => Data Validation => List


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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top