Do Not Save İf The Entered Data İs The Same Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Private Sub CommandButton1_Click() Dim x As Boolean x = False For i = 1 To Sheets("sheet2").Cells(65536, 1).End(xlUp).Row If TextBox1.Text = Sheets("sheet2").Cells(i, 1) And TextBox2.Text = Sheets("sheet2").Cells(i, 2) Then x = True MsgBox ("Mükerrer kayıt") Exit For End If Next i If x = False Then Sheets("sheet2").Cells(i, 1) = TextBox1 Sheets("sheet2").Cells(i, 2) = TextBox2 End If End Sub Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 do not save if the entered data is the same 2 remove sheet / page protections 3 excel operators hk 4 specify partition, list how many files you have 5 backs up the workbook 6 backs up your book to a floppy disk 7 do not open excel file after a certain date 8 forms do not allow x to exit 9 send alert e-mail from microsoft outlook 10 download files from the internet 11 fonts in word 12 excel fonts 2 13 Highlight Specific Text: Suppose you have a large data set and want to control a specific value. You can use this code for this. When you run, you receive an input box to enter the value to search for. 14 Adds sheet / pages based on data in column A and writes data up to column D 15 floppy disk backup 16 book backup to floppy disk 17 book backup 18 book backup 19 dialog box without userform 20 automatic image fetch