Sorry, I'm new here...Not sure if I posted this in the right section...But I need help...
I made a textbox and I need to write an If/Else statement
Here it is: But It doesn't work...
Code
If CDBL (txtMaxPayment.Value) > Range("C9") Then
Range("C9").Font.Color = RGB(0, 0, 0)
Else
Range("C9").Font.Color = RGB(255, 0, 0)
This is what I have to do...At the end of each procedure I have to include a check that determines if the Monthly Payment in cell C9 is greater than the Maximum Monthly Payment (the textbox I created)...If so, I have to set the font color to RED in C9....Help plz...I'm going crazyyy....I have to use the syntax, CDBL(txtMaxPayment.Value) to make the Maximum Monthly Payment a numeric value...