Posts by chenyx70

chenyx70 · Oct 26th 2020

textbox 1 = check duplicate of QR code in excel spreadsheet. If duplicate msg box indicate duplicate & user need to enter new QR code.

chenyx70 · Oct 23rd 2020

I'm looking for code by check duplicate item in one of the textbox. I'm trying below code but its doesn't work.

Code

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1.BackColor = vbWhite
If Application.WorksheetFunction.CountIf(Worksheets("Sheet2").Range("A6:A1048559"), TextBox1.Text) > 0 Then
MsgBox "Duplicate QR Code"
Cancel = True
End If
End Sub

Display More

YF

I'm facing issue to find duplicate item in textbox