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
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