Transfer data from userform to macro in a module, and textbox input as numbers?

[flabb]

Hi.
I have a user form with 3 text boxes. In all of these are there numbers to be entered.
I then use the input to insert in a sheet with formulas which uses the inputs. But after the macro is run, I see a yellow triangle that tells me the cell is formatted as text. As I have another macro running tests with the numbers, it is too late to convert the cells afterwords. I have to convert them in the user form or maybe at the start of the macro?
How do I do that?
I have experienced that formulas using cells (with numbers) formatted as text can mess things up (without giving a warning, in other words without sending an error message...! And that is dangerous!

Anyways, here is the background for what I do;
I would really like to "transfer" a input from the textbox in the user form directly to a macro in a module, but I don't know how so instead I use cell "P1" as a temporary range, saying in the sub button_click (in userform) that range("P1")=textbox1.value then call macro1. And in macro1 I say numberIwant=range("P1"). But this gives me sometimes weird answers (and always formatting the cell to text).
Please help me with either formatting or to transfer the number from the textbox in userform to a macro in a module.

Thanks in advance!!!!

[protonLeah]

You did not attach a sample, but to write the values from the form's textboxes you can use something like:
Range("A1").Value = CDbl(textboxX.Value) to convert the text data to an Excel numeric value. Use CDbl if you have decimal values and CLng if it's alway whole (integer) values.

[jomili]

Here's a great resource for how to pass and use the data from your userform: http://peltiertech.com/Excel/PropertyProcedures.html

[flabb]

Thanks you guys!!
ProtonLeah; it worked perfect!!!
jomili; thanks, read it. But I (as a noobie) find this link easier to understand :-)
http://stackoverflow.com/questions/2...-module-in-vba

Anyways, thanks for helpful and quick answers!!!