RowCount = Worksheets("inserimento").Range("b1").CurrentRegion.Rows.Count
RowCount = Worksheets("inserimento").Range("b1").CurrentRegion.Rows.Count + 1
' Scrive i dati inseriti sul modulo ActiveSheet.Unprotect lr = Cells(Rows.Count, "B").End(xlUp).Row + 1 With Worksheets("inserimento").Cells(lr, 2) .Offset(, 0).Value = Me.TextBox1.Value .Offset(, 1).Value = Me.TextBox2.Value .Offset(, 2).Value = DateValue(Me.TextBox3.Value) .Offset(, 3).Value = Me.ComboBox1.Value .Offset(, 8).Value = Me.TextBox4.Value .Offset(, 9).Value = Me.ComboBox2.Value If Me.CheckBox1.Value = True Then .Offset(, 11).Value = "F" Else .Offset(, 11).Value = "M" End If End With