I am using a combo box to select from a very long list. In order to save
repeating the process of selecting from the combo box on each sheet in the
workbook I would like to transfer the value displaid in the first combo into
a cell on each of the other sheets. The list is too long to use the @CHOOSE
function.

Any ideas?

Thanks.