If More Than 2 Characters Are Written İn The Textbox, İt Will Switch To The Other 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 TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Select Case Len(TextBox1.Value) Case Is >= 2 TextBox2.SetFocus Case Else TextBox2.Value = "" End Select 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 If more than 2 characters are written in the textbox, it will switch to the other textbox 2 If more than 2 characters are written in textbox, the other textbox will send a message. 3 excel operators hk 4 separates the text in the active cell into letters (columns) 5 adding two lines and removing total 6 a .bat file from a floppy disk 7 opening calculator 8 1 more than 1 in the list 9 Can the characters typed in the inputbox appear as "*****" (password or password characters)? 10 if the number of letters is more than 100 write to the bottom cell 2 11 Write to the bottom cell if the number of letters is more than 100 1 12 Multiply All Values by Number: You have a list and you want to multiply the entire number by a specific number. Just use this code. Select this range of cells and run this code. first, it will ask you the number you want to reach more than one person, and then all their numbers will be multiplied instantly. 13 calculator on / off 14 automatic image fetch 15 change properties of multiple textboxes 16 delete duplicate / duplicate rows 17 select characters in textbox with arrow 18 65536 more than the other sheet I want to throw .... 19 remove sheet / page protections 20 Create a user-defined menu / Create your own menu and assign a macro to them in the "Extensions" section