Help with copy/paste sub

[escelnewbie]

Hello,
I need help with a sub that that will copy a name from selected drop
down list and paste it to a designated cell , but if the cell is not
blank then paste on the next cell down if blank, if not then next
down...ect. to a range of 15 cells.

 

[isabelle]

hi,

a "drop down list" can be a ComboBox control or a data validation list
or a ComboBox form, what is yours?

isabelle

Le 2013-01-30 12:22, escelnewbie a écrit :

 

[escelnewbie]

hi,

a "drop down list" can be a ComboBox control or a data validation list
or a ComboBox form, what is yours?

isabelle

Le 2013-01-30 12:22, escelnewbie a écrit :-

 

[isabelle]

there is a possibility to use the Calculate event. What is the address
of the data that feed the validation list? i hope that this data is on
another sheet.

isabelle

Le 2013-01-31 09:56, escelnewbie a écrit :