Userform add text when duplicate values are selected matching data criteria

[KK1234]

Hi,

I am having a very well constructed userform.
It works fine ( Thanks to the forum members' help)

I have Combobox1 & 2 ( Have dependent list for combobox2)

I want to create a leble14 which populates text ( In Red) ' Duplicate Entry, Check again' when combination of combobox 1 & 2 matches Text with in columns C & D
otherwise text remains blank ( white)

However it will allow user to ignore this and proceed using the form.

Please Login or Register  to view this content.

Any help please
Kind regards

[AndyLitch]

Create your label4 at design time and set the visible property to false Then try this code

Please Login or Register  to view this content.

[KK1234]

Hi AndyLitch,
Very well done Sir.
It works perfectly.
Thanks very much for your kind help.
Last question. Basic though.
How do I make the font colour to Red?
The properties do not have provision for red colour.
I have clicked * to thank you. wish I could click five stars.
I am closing the thread as the main question has been kindly resolved by you.
Thanks again
Kind regards

[AndyLitch]

Change the forecolor property

You're welcome mate and thanks for the rep.