Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi Manuel,
Thank you. I prefer to use macro in this case.
Please share with us macro, once you finished with validation. This will be helpful for others
Sure. I'm leaving for the day. I will update the thread by Monday.