i have a spreadsheet that has 3 worksheets, on each worksheet there is
a combo box, all 3 combo boxes are linked to the same range of data
with the same linked cell. some times I enter a value into the linked
cell manually, i then want this value to be displayed in the combo box
even though i do not wish this to be selected from a list.

When I change the valu in the linked cell manually and i go to sheet 1
i can see the value displayed in the combox box, however i cannot see
it in sheets 2 and 3, just the last selection that was made from those
combos

any help greatly recieved