i would like to add a fuction to a userform quite useless but it might help me somehow
so i have 30 textboxes with numbers from 1 to 30 textbox1, textbox2, etg. but i can change them and after the values of cells that are linked. but i dont want to have same number for example 2 times the number 3 and that means another number is missing and that before to input that changed values in workbook so a code that loop through to textboxes and in exit would pop up msg saying duplicate value would make my work. i found some code in web but dont do this that i imagine. so after many hours i came for your help