Conditional Data Entry İnto Textbox 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 TextBox3_Exit(ByVal Cancel As MSForms.ReturnBoolean) If TextBox3 "" Then If Val(TextBox3) > Val(TextBox2) Then Select Case MsgBox("Textbox 2 den büyük veri girişine izin verilsin mi...!", vbYesNo Or vbInformation Or vbSystemModal Or vbMsgBoxRight Or vbDefaultButton2, "yüksek rakamlı veri girişi") Case vbYes TextBox3.Value = Format(TextBox3.Value, "#,##0.00") TextBox2.Value = Format(TextBox2.Value, "#,##0.00") TextBox4.SetFocus Case vbNo Cancel = True TextBox3.Value = "" End Select End If 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 conditional data entry into textbox 2 excel operators hk 3 force to enter data into textbox 4 Forcing data into textboxes 5 data that you type into the texbox in your userform is simultaneously printed to cell a2 in your excel worksheet 6 after data entry into cells 7 importing data into the listbox 8 number of sheet / page prints with message box (prints even if the sheet / page is blank) 9 identifying unique (single) data entries 10 show data in cell in txtbox 2 11 See data in listbox & textbox 12 Sort the days of the month into textboxes when you select the year in combobox1 13 print button Do you want to preview the sheet / page to be printed 14 show data in cell in txtbox 1 15 a1e force to enter date with vba 16 Importing data from a text file (all data one by one) 17 Throwing data in the Clipboard and reading / inserting data into memory 18 prints cells with data 19 inserts the date and time when data was entered into the cells where data was entered on the active sheet / page as a comment 20 prints all sheet / pages with data or scans but does not print