Looping Through Userform Controls

Hello again:
I am currently using the following macro to calculate the cost of a recipe entered using a userform (frmRecipeBox) and then storing the information in tblRecipes on Sheets("Recipe Box"). My question is this, is it possible to reduce the amount of code by using a loop? I have played around with somethings and did a lot of searching but can't find amything that works for me. Again, I am very new at all this and learning as I go. I actually need to calculate the cost of 15 ingredients making the code almost 3 times the amount however that is too much text to post here. I am afraid that so much code will invite trouble at some point.

Please Login or Register  to view this content.

I tried this code but it gave an error at

frmRecipeBox.Controls("Cost" & I).Value = Application.VLookup(myIng, MyRange, Res, 0) * myAmt

Couldn't find the object. There is no control named "Cost". There is a cost textbox for each ingredient (Cost1, Cost 2........Cost15). These controls do not get saved to the table. They are just used to calculate the total cost of the recipe by looking up the cost of each ingredient, adding them together and putting the result in the control named rec65. There is a naming pattern for the controls that are being added to the table row. They are named rec1 to rec 68.
I am attaching a copy of my form and the complete macro so you can get a better idea. What if I changed the naming patterns to something like Ing1....Ing15; Amt1....Amt15, etc.
Thanks

You are right. Incomplete file. SortByRecipe is a macro and can be commented out.

Sorry. You are right. There is a typo there. I will try the code again when I get a chance and let you know how it went. Thanks

This code does not work as is, but I don't have time right now to look closer. I will let you know how I make out. Thanks

Thanks Norrie. You are right, there was a type. I saw that earlier but I don't know enough about loops to actually recognize it as a typo. I tried the code again with the typo corrected and I am getting calculations but not on all ingredients all the time, which makes very little sense. Actually my original code was doing the same thing so the problem likely lies with my naming pattern or something. I don't have time at the moment to play with it but I will let you know how it goes. Thanks again.

Eukeka!!!!!! I found the problem. Once I made the correction to the typo AND fixed a couple of data errors in the underlying data table, all is working. I had imported the real table data after I had my original code working and I didn't notice that there were a few entries in a column that didn't follow the proper data validation. Anyway, I am marking this thread as Solved.
Thank you everyone.

Resolved. Thanks anyway. I used Norie's code (with typo corrected). Works well.