Convert Userform input from text to number ???????

[Jim Stewart]

My userform takes the input and puts it into the proper cells. However, it is stored as text. Is there a way to convert it to a number prior to posting it in the cell????
If you can make this happen, I'll try to dance at your next wedding with cowbells on.
Jim

 

[Anthony47]

Hi jim,
I should try moving the contents of the textbox to a variable declared as one of the numeric formats (eg Dim MyNumVar As Double) and then moving from the variable to the excel cell.

I think this should work.

Bye,

 

[Jim Stewart]

Well, guess I'll have to dance at my own next wedding as I solved it myself. Simple place ".Value" after the input code. Hope others can use this.

 

[amitsk77]

Thanks Jim Stewart. I've been looking for this explanation for half an hour...thanks for posting this 10 years ago

 

[BarryJohnson]

Thanks also to Jim Stewart the .Value works perfect.
Worth the 10 year time travel

 

[johnohio]

17 years later another big THANK YOU!