Hi guys, I'm new to this forum so hoping someone can help me with this problem I have.

I have a user form which pulls data off a data table when a name is selected in the combo box, and then displays several certificate expiry due dates.

In the data table I have a list of names (work colleague's) with certificate date entries.
These date entries are conditionally formatted to change font colour when overdue, this works fine using conditional formatting.

Not every work colleague's certificate date, is out of date at one particular time.

However, when I pull the data up in the the user form the font for the dates in the textboxes remains black, regardless of colour in the database.

In a nutshell,
I'm looking for the dates to be red in the user form text boxes when red in the database, otherwise black.

Really been scratching my head over the VBA code for this, hope someone can help.