ActiveX ComboBox Linked Cell

  • Thread starter Thread starter kittronald
  • Start date Start date
K

kittronald

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.
Click to expand...

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
 
Back
Top