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