MichaelRSnow
Active Member
- Joined
- Aug 3, 2010
- Messages
- 409
Can anyone explain why the msg box won't appear? if work if the Optionbutton11 if statement is removed?
If OptionButton11 = True And Range("M26") > 75 Then
MsgBox "The LTV is greater than 75%, the new LTV Cap Rules will apply and the case must proceed on Repayment Only, alternatively the loan amount can be reduced." & vbLf & vbLf & _
"The LTV is currently = " & Format(Range("M26").Value, "#,##0.00") & vbLf & vbLf & _
"If the customer is porting their existing balance, and this balance is on Interest Only or Part and Part they can continue to do so"
End If
If OptionButton11 = True And Range("M26") > 75 Then
MsgBox "The LTV is greater than 75%, the new LTV Cap Rules will apply and the case must proceed on Repayment Only, alternatively the loan amount can be reduced." & vbLf & vbLf & _
"The LTV is currently = " & Format(Range("M26").Value, "#,##0.00") & vbLf & vbLf & _
"If the customer is porting their existing balance, and this balance is on Interest Only or Part and Part they can continue to do so"
End If