Index Properties

J

JeffYowell

New Member
Joined
Apr 29, 2002
Messages
1
Hello,
I am trying to create an excel spread sheet with several combo_box controls on it. In the programming I would like to extract the data from the combo_box's using a for next loop. However the method of using a for next loop in VB would be to name all the combo_box's the same name and use and Index array ComboBox(0,1,2,3,4...). Is this process still possible in VBA? I get an error when I try to name two combo_box's the same name.

Thanks

Jeff
jeffy@mccrometer.com
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
You must log in or register to reply here.

Similar threads

K
  • Solved
making a userform components attribute names and values a two dimensional array.
Replies
1
Views
221
dmt32
D
Dugzilla
  • Solved
Index Match not matching
Replies
8
Views
336
Dugzilla
Dugzilla
P
  • Locked
  • Question
VBA: how to refer to an element in a named range (array/matrix)
Replies
1
Views
158
Fluff
Fluff
P
  • Solved
how to refer to an element in a named range (array/matrix)
Replies
2
Views
198
Pascalvrolijk
P
N
  • Solved
For next loop with array and using a variable in range().select
Replies
5
Views
130
notmeiquit
N

Forum statistics

Threads
1,214,650
Messages
6,120,736
Members
448,988
Latest member
BB_Unlv

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top