combobox changes value
 

when you click on the dropdown button of a combobox and select a value.
afterwhich if you select any cell within the sheet. the value changes.
however, when you select the combobox it displays the value selected

any solutions?