drop down combobox

[alexanderd]

i hava drop down combobox which spans 3 colums and is approx 1000 line
long. I would like to be able to double click a line to copy it t
another worksheet. any one any ideas on how to accomplis
this:confused