Formatting Userform data to number as inputed into worksheet

[grwalker]

I have medium knowledge of excel however I have a form, which is formatted to only accept numbers, that upon completion adds that data to certain cells in a worksheet, of which cells are also formatted as numbers.

However, somewhere in my data it must change it back to a text as the autosums which calculate the data upon entry does not recognise the data as numbers as I get #Value error in the sum cell.

Ive tried:

Sheets.("Weekly Report").Range("Textbox1") = CDbl(Textbox1)

and

Sheets.("Weekly Report").Range("A1").Value = Me.Textbox1.Value

Can someone please assist in determining which code is affecting the data?

 

[Kenneth Hobson]

Sheets.("Weekly Report").Range("A1") = Val(Textbox1)