Private Sub CommandButton3_Click()
Dim LastRow As Integer
Const intColor As Long = 13998939
Dim sht As Worksheet
Set sht = Sheets("Word1")
sht.Activate
LastRow = sht.Cells(ActiveSheet.Rows.Count, "A").End(xlUp).Row + 2
If MsgBox("Wijzigingen doorvoeren ?", vbYesNo, "Wijziging") = vbYes Then
x = SpinButton1.Value
With sht
With .Cells(LastRow, 1)
.Value = "Naam"
.Interior.Color = intColor
.Font.Color = vbWhite
End With
With .Cells(LastRow, 3)
.Value = "Voornaam"
.Interior.Color = intColor
.Font.Color = vbWhite
End With
With .Cells(LastRow + 1, 1)
.Value = "Geb. Datum"
.Interior.Color = intColor
.Font.Color = vbWhite
End With
With .Cells(LastRow + 1, 3)
.Value = "Geslacht"
.Interior.Color = intColor
.Font.Color = vbWhite
End With
With .Cells(LastRow + 2, 1)
.Value = "Email"
.Interior.Color = intColor
.Font.Color = vbWhite
End With
With .Cells(LastRow + 2, 3)
.Value = "Mobiel"
.Interior.Color = intColor
.Font.Color = vbWhite
End With
With .Cells(LastRow + 3, 1)
.Value = "Adres"
.Interior.Color = intColor
.Font.Color = vbWhite
End With
With .Cells(LastRow + 4, 1)
.Value = "Nummer"
.Interior.Color = intColor
.Font.Color = vbWhite
End With
With .Cells(LastRow + 5, 1)
.Value = "Foto"
.Interior.Color = intColor
.Font.Color = vbWhite
End With
With .Cells(LastRow + 6, 1)
.Value = "Tes"
.Interior.Color = intColor
.Font.Color = vbWhite
End With
.Cells(LastRow, 2).Value = txtNaam.Text
.Cells(LastRow, 4).Value = txtVoornaam.Text
.Cells(LastRow + 1, 2).Value = txtgeb.Text
.Cells(LastRow + 1, 4).Value = txtGesl.Text
.Cells(LastRow + 2, 2).Value = txtEmail.Text
.Cells(LastRow + 2, 4).Value = txtMobiel.Text
.Cells(LastRow + 3, 2).Value = txtAdres.Text
.Cells(LastRow + 4, 2).Value = txtNo.Text
.Cells(LastRow + 5, 2).Value = txtFoto.Text
.Cells(LastRow + 6, 2).Value = txtTekst.Text
End With
End If
End Sub