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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Iterating through a ComboBox's values 6
Populate combobox 6
Variable Data Type 4
LinkCell Property 1
linked cell math help 0
A form combobox with list style as options. 1
Problem when Combo box has linked cell as a number 4
Worksheets, comboboxes, and integer values 1

Back
Top