PDA

View Full Version : ComboBox with 1 to 100



tonyrosen
11-18-2005, 01:33 PM
Okay, totally stuck on looping from 1-100 and populating a combo box dropdown.

Basically, what I WANT to do is:
For i = 1 To 100
Populate My Stinkin' Drop Down
Next

But, I'm missing syntax.

mvidas
11-18-2005, 01:59 PM
Hi Tony,

It isn't working like this?For i = 1 To 100
ComboBox1.AddItem i
Next
If not, you could try it like: Dim AnArray() As String
ReDim AnArray(1 To 100)
For i = 1 To 100
AnArray(i) = CStr(i)
Next
ComboBox1.List = AnArrayMatt

tonyrosen
11-18-2005, 02:03 PM
Okay, starting over ... I may just be a moron. I said "may", don't run with that ...



I'm thinking that i'll just number a range with a 100 stinkin' numbers in it and use a DataValidation dropdown.... sheesh