Userform textboxes font color change

[Kwastarn]

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.

[Keebellah]

Hi, welcome to the forum.
The same formula you use in Conditional Formatting you can use in the Userform's vba code
You use write a Function that returns the wanted colour and use it in the Textbox properties. Its the BackColor you will want

You can also read here and use the cell colour that you have based on the conditional formatting
https://stackoverflow.com/questions/...xcel-using-vba

Let me/us know if you need more help

[Kwastarn]

Thank you for your help, all sorted now.