VBA code for introducing hours in ComboBox

Hi,

Im looking the way of introducing hours in a ComboBox using a VBA code.

The only solution I have already find is doing this:

Please Login or Register  to view this content.

And then in Range (A1:A289) I put the following hours:

00:00
00:05
00:15
00:20
00:25
00:30
00:35
00:40
00:45
00:50
etc...
...
...
...
23:45
23:50
23:55
24:00

As I said, this is what I have already manage to do as a solution but Im sure there must be an easiest way of doing it. It would be great (and its what Im forward to) to do this code with all data in the VBA, without putting in any Sheet of the workbook all the dates in a Range.

Thanks a lot

Regards,


pezalmendra

Hi, pezalmendra,

I assumed a CB on a Userform:

Please Login or Register  to view this content.

Ciao,
Holger

Holger,

Thank you very much! Just what I was looking for