Combo Boxes

[Guest_imported]

Hello,

I,ve put a combo box on a user form.

That is as far as i can get unfortunately.

Can someone tell me how to write a list for this combo box?

It's a simple list of numbers i require ie 01 02 03 04 and so on to 60.

Thanks

Andrew

 

[Loomah]

Hi guesser
Not sure a combo box is what you want but I'm only guessing!!

This will ad no's 1 - 60 in format ie 01 not 1

Private Sub UserForm_Initialize()
Dim i As Integer
For i = 1 To 60
ComboBox1.AddItem Format((i), "0#&quot
Next
End Sub

Oh, the code goes in the Form's module.

;-)
2 days to go If a man says something and there are no women there to hear him, is he still wrong?