Convert text in a textbox to a number (VBA)

[jkj115]

I have a textbox where after the user inputs a number (100000) the afterupdate event formats this as text

Please Login or Register  to view this content.

When I want to work with this value in the code (i.e. to perform other math) I need to convert this back to a number. Is there a simple way to do this? I don't want to set up the textbox to have a controlsource for other reasons

[berlan]

For instance, you can try -- before the variable to convert to number or use CDbl() to convert to double:

Please Login or Register  to view this content.

Cheers,
berlan

[jkj115]

Hey Berlan,

What if my textbox is a percentage, such as 11.5%. I think the Cdbl function results in a mismatch error.