Change userform texbox value to number after submitting to wks

[clemsoncooz]

You might laugh when you see how easy this is.

But I have done mutiple google searches and I cant find anything that I understand. I know the answer is easly out there - I just cant understand it.

When you look at the simple attached userform, how do I make sure that when the value is entered into my worksheet, it it gets entered as a number and NOT text?

You will see that if they user trys to type text, they automatically get a msgbox saying numbers only - but its when they do enter a number and hit "OK" is when it still gets added as text.

Please help and thanks in advance.

Please Login or Register  to view this content.

And to further add to my request - I want what is submitted to the worksheet to be in a 0.0% format. So if 25.6 is added to the userform, I would like 25.6% to be added to the worksheet.

[buran]

Hi
Simply convert the value from the textbox

Please Login or Register  to view this content.

Also look at the other different type convertion functions e.g CLng, CDbl, CDec, etc. you may prefer one of them.
Buran

[buran]

Even better, to avoid dealing with different numeric types use this

Please Login or Register  to view this content.

It will convert the number to the proper type

[clemsoncooz]

Cool. Thanks buran. That helps!

What about this request?
And to further add to my request - I want what is submitted to the worksheet to be in a 0.0% format. So if 25.6 is added to the userform, I would like 25.6% to be added to the worksheet.

[buran]

even better, to avoid dealing with different numeric types use this (also formatting request)

Please Login or Register  to view this content.

umeric type

Val will convert to proper numeric type

Buran

[clemsoncooz]

This is just what I was looking for.

Thank you!