Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature currently requires accessing the site using the built-in Safari browser.
Private Sub CommandButton1_Click()
Dim i As Integer
TextBox2 = ""
i = 0
Do While Not Cells(i + 1, 1) = ""
i = i + 1
Loop
Randomize
wert = Int((i * Rnd) + 1)
TextBox1 = Cells(wert, 1)
End Sub
Private Sub CommandButton2_Click()
Dim i As Integer
i = 1
Do While Not Cells(i, 2) = TextBox2
i = i + 1
Loop
If i = wert Then
MsgBox ("Richtig")
Else
MsgBox ("Falsch")
End If
End Sub
Do While Not Worksheets("Vokabeln").Cells(i, 2) = "" 'Prüfen ob man noch innerhalb der Tabelle mit Daten ist
If Worksheets("Vokabeln").Cells(i, 2) = TextBox2 Then Exit Do 'Vokabel gefunden.
i = i + 1
Loop
' Ausgabe der richtigen msgbox bestimmen
If i = wert Then 'Prüfe ob i = wert ist.
msgbox = "Richtig"
Else
msgbox "Falsch"
End If
TextBox1 = ""
TextBox2 = ""