vendredi 6 juillet 2018

Userform TextBox not Reading Large Numbers

I have a userform that opens a userform if condition 1 or condition 2 are met, if not then it opens a msgbox. Condition 1 is If deptotal.Value > "250,000" and Condition 2 is equitytotal.Value > "80". I was testing it out and for some reason my userform wont open a value of 100,000,000, even though it is greater than 250,000. It will work with 300,000,000. Not sure what I am doing wrong. Here is my full code:

Private Sub rec_Click()

    If deptotal.Value > "250,000" Or equitytotal.Value > "80" Then

        UserForm4.Show

    Else

        If deptotal.Value < "250,000" Or equitytotal.Value < "80" Then

            MsgBox "No Recommendations to Show as of Now"

        End If

    End If

End Sub

Aucun commentaire:

Enregistrer un commentaire