AW: Uhrzeit in TextBox laden
ransi
hallo denis
versuch mal so:
Private Sub ComboBox1_Change()
If ComboBox1.Text = Range("A1") Then
TextBox1.Text = Format(Range("B1"), "hh:mm")
TextBox2.Text = Format(Range("C1"), "hh:mm")
End If
If ComboBox1.Text = Range("A2") Then
TextBox1.Text = Format(Range("B2"), "hh:mm")
TextBox2.Text = Format(Range("C2"), "hh:mm")
End If
If ComboBox1.Text = Range("A3") Then
TextBox1.Text = Format(Range("B3"), "hh:mm")
TextBox2.Text = Format(Range("C3"), "hh:mm")
End If
End Sub
ransi