Selection from combobox is text not number!

[DaddyWeg]

Hello Everyone!

I have two selections in a combo box. Both are numbers. However, when I select either one and it enters that value in the linked cell, it is seen as text instead of a number. Is there a way to fix this so that every time a selection is made it is returned as a number?

 

[bydesign]

Yo DaddyWeg

1) make sure the cell your putting your data in is formatted as number... or currency depending on whatever you need.

2) Values can be converted between text and values as required
For example...
combobox data to number... Range("MyValueRange") = val(combobox.value)

cell value changed to a string... Range("MyTextRange") = str("MyValueRange")

 

[DaddyWeg]

It worked! Thanks again for helping this beginner.

 

[sswcharlie]

Have same problem, but I am not using VBA, just the normal properties box. How do I change that to work with numbers

Charlie

 

[engineer27]

Plz help me ! I can not understand how do you convert the text to number.

plz helpppppppppppppppppp

 

[micthemouse]

This is just the fix I need, but where exactly do I put the code...

Range("MyValueRange") = val(combobox.value)

I tried several different ways, but none of them worked.

Thanks for your help.

 

[inneedofanswers]

Yo DaddyWeg

1) make sure the cell your putting your data in is formatted as number... or currency depending on whatever you need.

2) Values can be converted between text and values as required
For example...
combobox data to number... Range("MyValueRange") = val(combobox.value)

cell value changed to a string... Range("MyTextRange") = str("MyValueRange")

I have a list that has both numbers and text how do I have the combobox display both?

 

[mikerickson]

A ComboBox only contains Strings, never numerical types.

A combobox might contain a numeral, but never a number (i.e. "12" not 12)

Similarly, ListBoxes, TextBoxes, Labels.

 

[inneedofanswers]

I have a list that's linked to my combobox that has both text and numbers how do I have both output into the linked cell correctly?

 

[mikerickson]

What do you mean "linked"? How? via .RowSource or some other method?

Is it causing errors now?