Schedules with Interval in combobox

[S P P]

Schedules with Interval in combobox

 

[vletm]

S P P

• When drafting a question, try and lay out the question in a clear and concise way.
• Try and tell the readers what is the situation, what have you tried and what do you want to achieve.
• Don't leave out information more info is better

 

[p45cal]

Private Sub UserForm_Initialize()
HI = TimeSerial(Planilha1.Range("B2"), 0, 0)
HF = TimeSerial(Planilha1.Range("C2"), 0, 0)
M = TimeSerial(0, Planilha1.Range("D2"), 0)
For I = HI To HF Step M
  ComboBox1.AddItem Format(I, "hh:mm")
Next I
ComboBox1.ListIndex = 0
End Sub

 

[S P P]

p45cal

Thanks

It was as needed

I got pretty close to what I wanted

 

[S P P]

if
B2 =08;30
C2 = 19:50
D2 = 00:20

I tried to change in the VBA that I wrote to have this other option

Swapping TimeSerial for Format but it didn't work.

Is there any way to help me if the time is fractional.

I'm already waiting

 

[p45cal]

Private Sub UserForm_Initialize()
HI = Planilha1.Range("B2")
HF = Planilha1.Range("C2")
M = Planilha1.Range("D2")
For I = HI To HF Step M
  ComboBox1.AddItem Format(I, "hh:mm")
Next I
ComboBox1.ListIndex = 0
End Sub

 

[S P P]

It didn't work something went wrong

 

[p45cal]

It would help if your code referred to the right cells.

 

[S P P]

p45cal
Sorry
It worked out
Forgot to change in VBA
B2 to B4