Filling comboboxes in loop - problem

  • Thread starter Thread starter S³awcio.xww
  • Start date Start date
S

S³awcio.xww

Hello Group!
I have problem with filling about 150 comboboxes (which was named A1, A2,
A3, etc...) in my form named MATRIX by command "additem".
My programmers platform is VB (v. 6.3 Excel 2003).
Example of my code I enclosed below:

For n = 1 To 12
For x = 1 To 100
MATRIX.Controls("A" & n).AddItem = x
Next x
Next n

After runing I have error: Object doesn't support this property ot method.
Error 438.
Do you have any ideas - how process this code?

Thanks a lot for your help.
Slawomir.
 
Private Sub CommandButton1_Click()
For n = 1 To 12
For x = 1 To 100
MATRIX.Controls("A" & n).AddItem x
Next x
Next
End Sub


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top