Thanks, but that copies the corresponding list value, not the actual value in
the combo box, and I would then need to use @CHOOSE to get the corresponding
data. As I said - the list is way too long for that!


"vezerid" wrote:

On Mar 8, 2:06 pm, LongTermNoob
wrote:
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.

Go to a cell in another worksheet where you would want your value
transfered. Type =. Without cancelling the editing process, navigate
to the sheet with the combo box and point to the linked cell. Click
and press Enter. Repeat for the other sheets. If it is the same cell
(e.g. F3) in all other sheets, then you can select all the other
shifts (Shift+click on the sheet tab) and do the process once.

HTH
Kostis Vezerides