Set a Value as Number (Number Stored as Text warning comes up)

[OberonViking]

The ComboBox4 is part of a Userform.

Please Login or Register  to view this content.

When I go to the spreadsheet it tells me that this is now Number Stored as Text. I need it to be a number not text so that other calculations work properly. Any ideas? What have I done wrong?

[Leith Ross]

Hello OberonViking,

Any value returned from a ComboBox or TextBox is always a text value. You can coerce the string to another type. This change to your macro converts the text to a double value.

Please Login or Register  to view this content.

[OberonViking]

Thank you. I'll be using this a lot.