Hi,
I am not an experienced user and I have an userform with 16 comboboxes. The boxes are named CoBo_IN_01_01, CoBo_IN_01_02 to CoBo_IN_04_04. They have to be filled with the following items: 0, 10, 20, 30, to 100.
I know how to fill the boxes in VBA code one by one using add item. THis is very slow by the way.
But I think it's possible to do it a lot quicker. Is it possible to fill the comboboxes automatically using a next i, next j construction for the box names?
I would greatly appreciate any help!
Thanks
Alex
I am not an experienced user and I have an userform with 16 comboboxes. The boxes are named CoBo_IN_01_01, CoBo_IN_01_02 to CoBo_IN_04_04. They have to be filled with the following items: 0, 10, 20, 30, to 100.
I know how to fill the boxes in VBA code one by one using add item. THis is very slow by the way.
But I think it's possible to do it a lot quicker. Is it possible to fill the comboboxes automatically using a next i, next j construction for the box names?
I would greatly appreciate any help!
Thanks
Alex