Hi,

Not sure what you mean by 'always stays in that cell'.

Do you perhaps mean the ControlSource property of the combobox which will read a specified cell value into the combobox, or update the cell value in response to a change in the combobox?