[VBA] How to add all elements of a list to a table?

Question

infographics

I have a list of ratings and a bunch of comboboxes for rating each of the list. I can add the first row from the list and one rating (combobox) to the table. How to run a loop for each row from the list and the ratings (combobox) related to them?

Answer 1

dear colleague. Firstly, to give ratings by choosing them from a combobox... Strange. It's easier to do three checks for the textbox: what is greater than zero, what is less than 5, and what is an integer value. It is possible, of course, that you meant items, but it is also a bit strange to select them from the combobox ... Rather, you need a listbox with a filter or a subform in general.
Those. already by the description of the task it is clear that you are doing it not very correctly, IMHO.
Why not leave it to the professionals? It will be much faster, as well as you can ask for comments on the decision.