Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling comboboxes in loop - problem
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling comboboxes in loop - problem
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) "Sławcio.xww" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling comboboxes in loop - problem
Thanks for your help. Now it is working. :o)
Slawomir. "Bob Phillips" wrote in message ... 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) "Sławcio.xww" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling ComboBoxes | Excel Programming | |||
Filling an array with a Loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming | |||
Filling down problem in VB | Excel Programming | |||
Invisible/unfindable Comboboxes creating .emf file problem... | Excel Programming |