AW: Makro Anzahl & Uhrzeit auswerten
30.05.2018 15:05:51
UweD
Hallo
so?
Dialog UserForm1
Private Sub A1_Click()
With A1
If .Value = True Then
.BackColor = &H8080FF
Felder = Felder & .Name & "-"
Else
.BackColor = &H8000000F
End If
End With
End Sub
Private Sub A2_Click()
With A2
If .Value = True Then
.BackColor = &H8080FF
Felder = Felder & .Name & "-"
Else
.BackColor = &H8000000F
End If
End With
End Sub
'usw.
Private Sub Fertig_Click()
'wenn Fertig geklickt wurde dann Übernahme alle ToggleButton.Value =True in Tabelle "Datenbank" erste leere Zeile, daran scheitere ich
Dim TB, LR As Double, Anz As Integer
Set TB = Sheets("Datenbank")
EndTime = Now
For Each objcontrol In Controls
Select Case TypeName(objcontrol)
Case "ToggleButton"
If objcontrol Then Anz = Anz + 1
objcontrol.Value = False
End Select
Next
LR = TB.Cells(TB.Rows.Count, "A").End(xlUp).Row + 1 'erste freie Zeile der Spalte
TB.Cells(LR, 1) = Format(Date, "DD.MM.YYYY")
TB.Cells(LR, 2) = Format(StartTime, "hh:mm:ss")
TB.Cells(LR, 3) = Format(EndTime, "hh:mm:ss")
TB.Cells(LR, 4) = Format(EndTime - StartTime, "hh:mm:ss")
If Felder <> "" Then
Felder = Left(Felder, Len(Felder) - 1)
Else
Felder = "KEINE"
End If
TB.Cells(LR, 5) = Felder
TB.Cells(LR, 6) = Anz
Me.Hide
End Sub
Private Sub UserForm_Activate()
Felder = ""
StartTime = Now
End Sub
Modul1
Option Explicit
Public StartTime As Date, EndTime As Date, Felder As String
LG UweD