Show mismatch names in a text box

[tamilarasu]

Hi All,

Good day!!.

I have a scenario and need your help on this. In my application, I just kept a input field to get the user inputs. Later, I'll do some calculation based on the inputs. I have a set of pre-defined names and the user should enter only these names ie. names are Material, Product, Prefix, SO and WG.

I have to display a message for the below cases.

* Invalid names entered other than the defined names (Eg Materials, PID's or AAAAA)

* Contains any blank cells

I don't want to message for the below cases,

* Same level updated by user multiple times

* Same input levels updated for all the cells with a valid name

Attached a sample file. Any help would be greatly appreciated.

P.S: It would be nice (If possible), if i can show the mismatch names also in another text box.

Thank you.

[tamilarasu]

Kushal,

This one is a sample file. I have some other validation checks in my original application. I will add the validation check code in one of the existing module. Thank you.

[tamilarasu]

Hi Manuel,

Thank you. I prefer to use macro in this case.

[Kushal_Chawda]

Please share with us macro, once you finished with validation. This will be helpful for others

[tamilarasu]

Sure. I'm leaving for the day. I will update the thread by Monday.