Private Sub UserForm_Initialize()
    With FormLogbook
        With .ComboBox1
            .List = [transpose(proper(text(row(r1:r12)*30,"[$-419]mmm")))] 'Заполнение данными ComboBox11
            .ListIndex = Month(Date) - 1
        End With
        With .ComboBox2
            .List = [transpose(row(r1:r31))] 'Заполнение данными ComboBox2
            .Value = Day(Date)
        End With
    End With
End Sub

.Value = Day(Date)

.ListIndex = Day(Date) - 1

VBE.ActiveVBProject.References.AddFromFile Environ("systemdrive") & "\PROGRA~1\COMMON~1\MICROS~1\OFFICE" & Val(Application.Version) \ 1 & "\ACEDAO.DLL"

Private Sub TextBox1_Change()
[a2].Formula = CDate(TextBox1.Value)
End Sub

Private Sub TextBox2_Change()
[a3].Formula = CDate(TextBox2.Value)
End Sub

Private Sub UserForm_Initialize()
TextBox1.Value = [a2].Text
TextBox2.Value = [a3].Text
End Sub

    With [tabl_logbook].ListObject
        If .InsertRowRange Is Nothing Then .DataBodyRange.Delete
    End With

Private Sub CommandButton2_Click()
    If [a1] >= [a2] And [a1] <= [a3] Then MsgBox "fgh"
End Sub

Private Sub TextBox1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
    Dim dt As Date
    With TextBox1
        If IsDate(.Value) Then
            dt = CDate(.Value)
            .Value = Format(dt, "dd.mm.yyyy")
            [a2].Formula = dt
        Else
            Cancel = True
        End If
    End With
End Sub

Private Sub TextBox2_AfterUpdate()
    Dim dt As Date
    With TextBox2
        If IsDate(.Value) Then
            dt = CDate(.Value)
            .Value = Format(dt, "dd.mm.yyyy")
            [a3].Formula = dt
        Else
            Cancel = True
        End If
    End With
End Sub
Private Sub UserForm_Initialize()
    Application.EnableEvents = 0
    TextBox1 = [a2].Text
    TextBox2 = [a3].Text
    Application.EnableEvents = 1
End Sub

    With Application
        .ScreenUpdating = 0
            With .ActiveSheet
                With Sheets("group")
                    .Activate: .[a2].Select
                End With
                .Activate
            End With
        .ScreenUpdating = 1
    End With

Private Sub ComboBox3_Change()
    On Error Resume Next
    With Intersect(Range("tabl_group[[#all]," & ComboBox3 & "]").SpecialCells(2, 23), [tabl_group[#data]])
        Me.ComboBox4.Clear
        With .Areas(1)
            Me.ComboBox4.List = IIf(.Cells.Count > 1, .Value, Array(.Value))
        End With
    End With
End Sub

Application.Transpose(Range("tabl_group").ListObject.HeaderRowRange.Value)

[transpose(tabl_group[#headers])]

Private Sub ComboBox3_Change()
    On Error Resume Next
    With Intersect(Range("tabl_group[[#all],[" & ComboBox3 & "]]").SpecialCells(2, 23), [tabl_group[#data]])
        Me.ComboBox4.Clear
        With .Areas(1)
            Me.ComboBox4.List = IIf(.Cells.Count > 1, .Value, Array(.Value))
        End With
    End With
End Sub

.SpecialCells(2, 23)

Function FileMD5$(sFilePath$)
    On Error GoTo err
    Dim byteArr() As Byte
    With CreateObject("adodb.stream")
        .Type = 1: .Open: .LoadFromFile sFilePath
        byteArr = .read
    End With
    With CreateObject("System.Security.Cryptography.MD5CryptoServiceProvider")
        FileMD5 = Join(Application.Dec2Hex(.ComputeHash_2(byteArr), 2), "")
    End With
    Erase byteArr
    Exit Function
err: Debug.Print "Ну не шмогла я, не шмогла"
End Function