my first post, hope I have the correct forum
I Need to add the same items to 20 dropdownlists at once, here is a simplified example
Private sub populatelist ()
Dropdownlistx.additem (“man u”)
Dropdownlistx.additem (“Chelsea”)
dropdownlistx.additem (“leeds”)
End sub
Dim x as integer
For x = 1 to 20
populatelist
next x
My problem is using the dropdownlistxIt don’t like mixing text and variable I tried
dropdownlist(x)
“dropdownlist” & x & “.additem”
tried dropdownlist[x]
is there a way to do this ?
many thanks in advance
I Need to add the same items to 20 dropdownlists at once, here is a simplified example
Private sub populatelist ()
Dropdownlistx.additem (“man u”)
Dropdownlistx.additem (“Chelsea”)
dropdownlistx.additem (“leeds”)
End sub
Dim x as integer
For x = 1 to 20
populatelist
next x
My problem is using the dropdownlistxIt don’t like mixing text and variable I tried
dropdownlist(x)
“dropdownlist” & x & “.additem”
tried dropdownlist[x]
is there a way to do this ?
many thanks in advance