kittronald expressed precisely :
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.

Congrats! ..glad I was able to be of help. Thanks for the feedback...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc