Is there a way to have an ActiveX ComboBox's LinkedCell output as a
number and not text ?


- Ronald K.

kittronald pretended :
> Is there a way to have an ActiveX ComboBox's LinkedCell output as a
> number and not text ?
>
>
> - Ronald K.

A combobox is a dropdown textbox, and so the answer to your Q is 'No'.
You can, however, convert the value to the appropriate numeric type if
IsNumeric(ComboBox1.Text)...

With ComboBox1
If IsNumeric(.Text) Then
CLng(.Text) 'convert to Long
CInt(.Text) 'convert to Integer
CDbl(.Text) 'convert to Double
'...
End If 'IsNumeric(.Text)
End With 'ComboBox1

--
Garry

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