I created a user form and when I enter a value as .8 for example I get an error but If I enter 0.8 in the user form the formula works fine. Also, when I'm deleting text in the userform I get an error. Is there an easy fix to this? Thanks for the help guys!


Private Sub TextBox1_Change()
Cohesion1 = ((TextBox1 - 0.34) / 0.31)
TextBox2 = Cohesion1
[End Sub