Garry,

Wow, thanks for the support - it works now !

From your examples, I've learned the following:

1) Sheet2.ComboBox1 is the same as Sheets("Settings").ComboBox1

2) Forms control code resides on a specific worksheet instead of
globally in the workbook

3) The code creates an event, that upon selecting a value from the
drop down list, formats the output as a number

4) The second line replaces the need to set the LinkedCell property

Thanks again !


- Ronald K.