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