Hello, I have three textboxes. I just want if user input a data in textbox1, for example "100", it will search in Sheet1 in Range A:A, if it finds duplicate like in Sheet1 A:A, msgbox will prompt "This account number was already used", if not then do nothing.
Bookmarks