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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.