Hello, Ive been loosing my mind trying to understand how to complete this macro based on a USERFORM.
The first If statement seems to work as planned.

Problem arises when I try to insure that the value a user inputs to the USERFORM/TextBox falls within Sheets(“BinConversion”).Range(“a” & I)
Anything outside of these numbers ">0 and <13" would MsgBox user to correct.

One of the secondary issues I can't seem to beat is if I backspace the TextBox to empty I get a Error 13 Mismatch (Debug: x = Bin1Input.Value
It's my limited understanding that the variable is a double and therefor an empty space is being read as a string, hence the mismatch.

Lastly, The looping is flawed as depending on how Ive tried to write the code. It either skips the first If Statement, or goes into death loop and I must restart Excel to stop the sub. 


Private Sub Bin1Input_Change()

Dim x As Double
Dim I As Double

x = Bin1Input.Value

For I = 4 To 28
If x = Sheets(“BinConversion”).Range(“a” & I) Then
Sheets(“QLDailySheet”).Range(“b6”) = Sheets(“BinConversion”.Range(“b” & I)

ElseIf x = IsEmpty Then
MsgBox “Please Enter A Measurement Between 1 and 13 Meters”, vbExclamation
End If
Next
End Sub