Validating Textboxes in a userform

[Faisal_Akkad]

Hello,

I have a userform with 6 textboxes to be filled by the user which will be used in generating a formula sheet, I need a validating code to perform duplicate check among all the 6 textboxes ,hope that was understandable..Thanks

 

[My Aswer Is This]

Re: Validating Textboxes in a userform...Please help

Do you want all the values in all Textboxes to be the same or not be the same.
Or do you mean you want to be sure all Textboxes have some value in them?

 

[Faisal_Akkad]

Re: Validating Textboxes in a userform...Please help

Do you want all the values in all Textboxes to be the same or not be the same.
Or do you mean you want to be sure all Textboxes have some value in them?

Hello ..thanks for replying... I need to assure all the textboxes with values are unique from each other no need to fill al the boxes
.thanks

 

[My Aswer Is This]

Re: Validating Textboxes in a userform...Please help

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

A script would have to search all textboxes and if they have a value determine if that is unique.

If you had 40 textboxes for example a loop would have to search 40 textboxes and make sure all are unique.