Good day to you all,

Here is the deal I have a UserForm which I use to input and edit data in a worksheet. Currently the Userform only uses Textboxes and accommodates up to 200 controls. I am working on another which will accommodate more controls, This time I would like to use Textboxes and ComboBoxes, I would also like to use Checkoxes and option boxes too. So I would greatly appreciate some assistance with this little project.

Here is an example of code I use in my aforementioned project which I was trying to modify to accomplish the same thing only this time with ComboBoxes and textboxes as controls. 

Dim t As Control, res As VbMsgBoxResult, i As Long, TextBox As Control, z As Control
Dim a As Long, b As Long
Dim x As Integer

a = Sheets("Student Info").Columns(1).Find(Reg1.Value, , , 1).Row
b = Sheets("Student Info").Cells(a, Columns.Count).End(xlToLeft).Column

For Each t In Me.Controls
    If TypeName(t) = "TextBox" Then
        If t.Text = vbNullString Then t.Text = ""
    End If
Next

For i = 4 To 253
    Sheets("Student Info").Cells(a, b + (i - 3)).Value = Me.Controls("TextBox" & i).Value
Next i

Unload Me
Any assistance re this matter, given the significance of the project I am undertaking, would be GREATLY appreciated.

If you guys would like to see the work sheet I was experimenting with I can provide same on request.