Combo Box Update

Hi,

My combobox is set to update everyone time there is a change to the particular worksheet. Its contents are also clear in order to prevent the combo box from continuously adding the same values to the sheet. However, this combo box is also linked to cell C30. Is there a way to prevent the value of C30 from being cleared everytime there is a change to the worksheet?

Thanks, code below.

Please Login or Register  to view this content.

Or break the link and apply the value to the cell on combobox_change?