It happens that kittronald formulated :
Garry,
Thanks for hanging in there.
Same error.
If Sheet2 has a name of "Settings", shouldn't Sheet2.ComboBox1 be the
same as Sheets("Settings").ComboBox1 ?
Also, the CLng, CInt and CDbl lines cause the following error to display:
Compile error:
Expected: identifier
- Ronald K.
Ok, if you're not able to get a qualified reference to the sheet where
the combobox is, OR the combobox itself, then you're also not going to
return any text values for converting to another data type. VBA will
raise an error in these cases. Question is why aren't you able to get a
qualified ref to the combobox and its text. I'd be able to better help
you if you post the ENTIRE procedure code that's raising these
exceptions.
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc