Garry,

After inserting the code in its own module, I've tried prepending with:

Forms.ComboBox.1

This is what displays in the formula box when I select the
ActiveX ComboBox

Sheet2.ComboBox1

Me.ComboBox1

Sheets("Settings").ComboBox1

None of these change the format of the linked cell.

Does it matter if this an ActiveX Combobox instead of a forms Combobox ?



- Ronald K.