pasan
Terugkerende gebruiker
- Lid geworden
- 6 nov 2010
- Berichten
- 1.110
met hulp eerder deze avond nog meer code kunnen inkorten maar helaas deze is me niet gelukt
Code:
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
ActiveSheet.Unprotect Password:=""
Dim x As Long
For i = 1 To 7
If Me("Ch" & i) Then
x = cells(Rows.Count, "BL").End(xlUp).Row + 1
With ActiveSheet
Range("BL" & x) = (DateValue(Me.Txtdatum))
If Me.ObBV = True Then
Range("BM" & x).Value = Txturen & ("B")
End If
If Me.ObSnipper = True Then
Range("BM" & x).Value = Txturen & ("S")
End If
If Me.Obziek = True Then
Range("BM" & x).Value = Txturen & ("Z")
End If
Range("BN" & x).Value = Me.TxtOpmerkingen1
Range("BK" & x).Value = Me.Txtnaam
End With
End If
Next
Unload Me
ThisWorkbook.Save
ActiveSheet.Protect Password:=""
Application.ScreenUpdating = True
End Sub