Hello
 I am trying to create a If Then Else If Statement That takes information from a text box and generates a piece of text in another text box (unbound) for example:

If TxtBox1 = <18.0 Then
 TxtBox2 = "Low"
Else If TxtBox1 = 18.0 Thru 20.0 Then
 TxtBox2 = "Good"
Else If TxtBox1 = > 20.0 Then
 TxtBox2 = "High"
End If

Not Sure What I Am Doing Wrong Here, But It Don't Matter What Number I Type In TxtBox1, TxtBox2 Always Shows "Low".

Any Information On This Would Be Helpful.

Thanks,
Ryan

---

Answer from Richard Rost:

Well, first of all "thru" isn't a valid word in VBA. Second, it's always better to get those text values into numeric variables. Try this instead:

Dim X as Double
X = CDbl(TextBox1)
If X < 18.0 then
  TextBox2 = "Low"
Elseif X >= 18.0 AND X < 20.0 then
  TextBox2 = "Good"
Else
  TextBox2 = "High"
End if

You don't need your last condition because it will catch everything 20.0 and up.

Hope this helps.