On Thursday, October 4, 2012 2:31:37 AM UTC-7, (unknown) wrote:
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

Just to clarify... when the linked cell is modified manually, you want the combo boxes to hold only this value? or do you still want it to hold the reference lists as well? If you do not change the linked cell manually, how do the combo boxes get their values? Your questions is a little confusing...

From what I gather you may want to enter an eventchange code into the sheet that has the linked cell to modify the values of the combo boxes in all three sheets.