help with looping code

hi, i have this piece of code in a SHARED workbook that i wish to loop, but do not know how to do it. what it is supposed to do is check whether the unique autopopulated value in textbox17 exist in the workbook column A. Example of the value is DVI-00120. This value will increase by 1 after users log in a sample. As this is a shared workbook, other users may have already used the value, and if left unchecked, will result in duplicate values.

the code below works only when the value in the last row of column A is the same as textbox17. if for example, i am holding onto DVI-00120 while other users have already progressed to DVI-00125, the below code only adds 1 to DVI-00120, making it DVI-00121, which is duplicating what is already in column A. So, i need the code below to keep checking until an available number is not used, which in this example is DVI-00126.

Sorry for the lengthy explanation

Please Login or Register  to view this content.

i solved it