Userform textbox sum

[Matthew1001]

Hi, I'm trying to make a condition in a userform that if deposit is less then property value * 0.05 then msgbox "etc"

However, when I run the code so that the deposit is less than propertyvalue * 0.05, the msgbox doesn't appear?

Any help would be greatly appreciated.

If the image I've attached doesn't work then here is the code I've written

If Deposit < PropertyValue * 0.05 Then MsgBox "Sorry, deposit must be a minimum of 5% of the property value"

Problem.png

[stnkynts]

Submit your workbook.

[Norie]

Is the code actually being executed?

PS Why do you have a loop for checking for numeric input for Deposit?

[Matthew1001]

Hi, I'm very new to VBA and so I'm struggling a bit. Someone else suggested putting a loop in there although I don't think it needs it. Do you mean I should upload my workbook onto here? Everything else I've done is working fine except for this, it wont execute it.

[Norie]

If Deposit is a textbox then you need to convert it's text value to numeric if you want to compare it with another numeric value.