Dear Expert,

I have created a add new supplier userform name each control the same and this example i have used the name Vendor. When you run the loop add a text string for each control called Vendor and add the variable X which stands for the variable [1-9] in the loop this creates consecutive names for each control.

help me how to write next loop.

please find the attached file for your reference.

Inventory.xls

for-loop.png