Here is some code that will change the color of the text in a Textbox on a User Form, based on the difference in dates between Today and a date in a worksheet cell:
If Worksheets("Sheet1").Range("A2").Value < Int(Now()) - 14 Then
Me.TextBox1.ForeColor = RGB(255, 0, 0)
Me.TextBox1.ForeColor = RGB(0, 0, 0)
Me.TextBox1.Value = Worksheets("Sheet1").Range("A2").Text
You will need to change the worksheet name and cell reference and the name of the Textbox on the user form.
The code could go in the user form Activate section.
Hope this was what you were looking for.