AW: Uhrzeit in ComboBox
15.10.2022 15:22:30
snb
3 Methoden:
Private Sub UserForm_Initialize()
ComboBox1.List = [transpose(text((row(1:96)-1)/96,"hh:mm"))]
ComboBox2.List = ComboBox1.List
End Sub
Private Sub UserForm_Click()
If ComboBox1.ListIndex > -1 And ComboBox2.ListIndex > -1 And ComboBox2 > ComboBox1 Then MsgBox Format(CDate(ComboBox2) - CDate(ComboBox1), "hh:mm")
End Sub
Private Sub UserForm_Initialize()
ComboBox1.List = [transpose(text((row(1:96)-1)/96,"hh:mm"))]
ComboBox2.List = ComboBox1.List
End Sub
Private Sub UserForm_Click()
If ComboBox1.ListIndex > -1 And ComboBox2.ListIndex > -1 And ComboBox2 > ComboBox1 Then MsgBox Format((ComboBox2.ListIndex - ComboBox1.ListIndex) / 96, "hh:mm")
End Sub
Private Sub UserForm_Initialize()
ComboBox1.List = [transpose((row(1:96)-1)/96)]
ComboBox2.List = ComboBox1.List
End Sub
Private Sub UserForm_Click()
If ComboBox1.ListIndex > -1 And ComboBox2.ListIndex > -1 And ComboBox2 > ComboBox1 Then MsgBox Format(ComboBox2.Column(0) - ComboBox1.Column(0), "hh:mm")
End Sub