title: VBA Textbox to number value
body: <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>