Hi,
I am pretty new to VBA and struggling to work this out.

I have a form used to enter data into a table. The data consists of one promotion & the promotion may have multiple products.
I have set up 10 separate textboxes to enter the ten different products (there may be even more products), name ProdNo1, ProdNo2 etc.

My question is, do I have to load all 10 Product TextBoxes separately, or is there some way to loop through the TextBoxes and perhaps have the name as a variable?

I am thinking something like this (somewhat like the INDIRECT function):

NoOfProducts = 1
ProductNumber = "ProdNo" & NoOfProducts

But it errors on the use of:
UserForm1.ProductNumber.Value

The ProductName appears to contain the correct data (ie ProdNo1), but it doesn't like it when used as part of the Object Name.

Does anyone know how to create a dynamic Object name, or alternatively a way to loop through adding the textboxes without having to code each one separately?

Thanks in advance for help,
janie

Dunno if it will help you or not, but if you type in userform1 (or whatever the name of your form is, intellisense pops up this:
So I'm guessing you could probably set up a looping structure to dynamically add textboxes based on some form control event. Hope that helps, good luck