hi, everyone

i am using below code to get cells value in textboxes according to combobox1 selection

Dim bul As Range, i As Byte
TextBox3 = Empty: TextBox4 = Empty: TextBox5 = Empty: TextBox6 = Empty: TextBox7 = Empty: TextBox8 = Empty:
TextBox9 = Empty: TextBox10 = Empty: TextBox11 = Empty: TextBox12 = Empty: TextBox13 = Empty: TextBox14 = Empty:
TextBox15 = Empty: TextBox16 = Empty: TextBox17 = Empty: TextBox18 = Empty: TextBox19 = Empty: TextBox20 = Empty:
TextBox21 = Empty: TextBox22 = Empty: TextBox23 = Empty
For Each bul In Sheets("OF EXT").Range("B2:B" & Cells(Rows.count, 2).End(xlUp).Row)
    If bul = ComboBox1 Then
    i = 0
     ' bul.EntireRow.Activate
        TextBox3 = bul.Offset(i, 4)
        TextBox4 = bul.Offset(i, 5)
        TextBox5 = bul.Offset(i, 6)
        TextBox6 = bul.Offset(i, 7)
        TextBox7 = bul.Offset(i, 8)
        TextBox8 = bul.Offset(i, 9)
        TextBox9 = bul.Offset(i, 10)
        TextBox10 = bul.Offset(i, 11)
        TextBox11 = bul.Offset(i, 12)
        TextBox12 = bul.Offset(i, 13)
        TextBox13 = bul.Offset(i, 14)
        TextBox14 = bul.Offset(i, 15)
        TextBox15 = bul.Offset(i, 16)
        TextBox16 = bul.Offset(i, 17)
        TextBox17 = bul.Offset(i, 18)
        TextBox18 = bul.Offset(i, 19)
        TextBox19 = bul.Offset(i, 20)
        TextBox20 = bul.Offset(i, 21)
        TextBox21 = bul.Offset(i, 22)
        TextBox22 = bul.Offset(i, 23)
        TextBox23 = bul.Offset(i, 24)
                
    End If
    
Next bul

i have 125 textboxes here and my offset is till 126

like
TextBox3 = bul.Offset(i, 4) to,,,,TextBox125 = bul.Offset(i, 126)

i want to do this process in simple way..

thanx a lot