P
Pete
How do I write a routine (xl97) to fill a combo box on a userform with
the time starting at 12:00 AM and ending at 11:45 PM?
I populated a combo box from the times on a worksheet and wrote this. It
works. (cells A1 thru A96 have 12:00 AM, 12:15 AM, etc...)
Sub build_combobox1()
Dim x As Date
With Worksheets("Sheet3")
For x = 1 To 96
ComboBox1.AddItem .Cells(x, 1)
Next x
End With
End Sub
But I rather build the data instead of getting it. Something like this
which does not work. (the value of x I can't figure out)
Sub build_combobox1()
Dim x As Date
For x = 1200 To 2400 Step 15
ComboBox1.AddItem Format(x, "hh:mm AMPM")
Next x
End Sub
the time starting at 12:00 AM and ending at 11:45 PM?
I populated a combo box from the times on a worksheet and wrote this. It
works. (cells A1 thru A96 have 12:00 AM, 12:15 AM, etc...)
Sub build_combobox1()
Dim x As Date
With Worksheets("Sheet3")
For x = 1 To 96
ComboBox1.AddItem .Cells(x, 1)
Next x
End With
End Sub
But I rather build the data instead of getting it. Something like this
which does not work. (the value of x I can't figure out)
Sub build_combobox1()
Dim x As Date
For x = 1200 To 2400 Step 15
ComboBox1.AddItem Format(x, "hh:mm AMPM")
Next x
End Sub