MSGBox win conditional Formatting is True

[DJRhino1175]

I have conditional formatting in a textbox based on a value of another textbox.

[Actual]>[Est Target]

When this code is true in turns the font Bold and Red of the txt box [Actual]

What I need help with is how do I trigger a msgbox based of this conditional formatting? Or would it be better to do an after update code that does the conditional formatting and trigger the msgbox?

[isladogs]

Hi
Apologies for the long delay in responding but there was an issue preventing anyone responding until now.
Have you fixed your problem in the meantime, or do you still need help?

[DJRhino1175]

Isla,

No I have not been able to fix this issue as of yet. I still need help.

[isladogs]

You could indeed use the AfterUpdate event to do both of these. For example:

Private Sub Actual_AfterUpdate()
    With Me.Actual
        If Me.Actual > Me.Est_Target Then
            .ForeColor = vbRed
            .FontWeight = 700 'bold
            MsgBox "Actual>Ext_Target", vbInformation, "Message Title"
        Else
           .ForeColor = vbBlack
           .FontWeight = 400 'normal
        End If
    End With
End Sub
 

Adjust as appropriate

[DJRhino1175]

Isla,

Thanks for the assist. I will give it a shot. It worked like a charm.

Thanks

[isladogs]

Glad I could help. Good luck with your project