Strange Textbox value problem

Hi,

I'm finding several problems with assuming textbox values to Sheet cells. This is strange because in some cases it works good and other very equal, doesn't.

If i want to assuma a textbox value that is numeric, at fisrt i wrote:

Please Login or Register  to view this content.

After this i founs some problems, because it wasn't assumed as a value, in the cell. After, i wrote:

Please Login or Register  to view this content.

Here is when the problems start. If i enter in the textbox a decimal number, it's assumed in the cell as a integer and doesn't present de decimal part. The strange thing is that in other cases, i simply put the 1st code presented (Sheet1.cells(1,1)=Textbox1.value) and assumes the decimal number correctly without reporting any strange behaviour.

The way that i used to round this problem was assuming at first the textbox value as a constant and after assuming that same constant to the cell. This way works fine.
But why does this strange behaviour happens??????

Anyone knows why?

Values from textboxes are added to the spreadsheet as text even if the value is numeric.

Try

Please Login or Register  to view this content.

or alternatively I think:

Please Login or Register  to view this content.

Hope this is what you need

Good!!!

The "CDbl" worked fine!

I still do not understand why in some cases is works fine and other not...but...it doesn't matter anymore

Thanks Roby!