Getting a number stored as text error when using a Userform Textbox

[colin7]

Hi,

I created a userform with textboxes. I want to be able to type numbers into the textboxes and update a table on my worksheet.

When I enter the numbers into the textboxes and update the table on the worksheet it says numbers have been saved as text.

Is there a way to convert these to numbers on my worksheet with VBA?

With Sheet7.ListObjects("tbl_Projects")
            Set lastRow = .ListRows.Add
            lastRow.Range.Value = Array(TextBox1, TextBox2, TextBox3, TextBox4, TextBox5, TextBox6, TextBox7, TextBox8, ComboBox1, TextBox10)
        End With

Textbox 7 and 8 will be numbers and the rest are text.

Thanks