VBA Textbox to number value
<p>I have this code and I need textbox 9 and 10 to be number vlaues when entering in my excel table any idea how I can fix this?</p>

<pre><code>Sub FillRanges(ws As Worksheet, L As Long)
With ws
    .Range("C" &amp; L).Value = (Now)
    .Range("D" &amp; L).Value = Me.TextBox2
    .Range("E" &amp; L).Value = Me.TextBox3
    .Range("F" &amp; L).Value = Me.TextBox4
    .Range("G" &amp; L).Value = Me.TextBox5
    .Range("K" &amp; L).Value = Me.ComboBox1
    .Range("L" &amp; L).Value = Me.ComboBox2
    .Range("M" &amp; L).Value = Me.ComboBox3
    .Range("N" &amp; L).Value = Me.TextBox9
    .Range("O" &amp; L).Value = Me.TextBox10
    .Range("R" &amp; L).Value = Me.TextBox39
    .Range("P" &amp; L).Value = Me.TextBox40
End With
</code></pre>

<p>End Sub</p>