VBA Issue: Code only runs halfway than stops.

Hello,

So I created a small application here is what it does: (Please dont be scared by the length of this post I am just writing in extreme detail to avoid confusion.) Also note that I commented out and had to remove some sections (You'll get what I mean once you see the workbook) to make the workbook under the 1MB file limit.

1. User opens form
2. User checks off all the checkboxes that refer to the drawings they want to add. (Open the form and this will make more sense)
3. They add the line number for each box and the qty for each box.
4. The hit add parts
5. The code in the MatForm runs
6. It duplicates preset sheets and renames them based on the captions of the checkboxes checked.
7. Than it adds material qtys to the "CutList" sheet again absed on the checkbox caption of checked off cehck boxes.

This works perfectly right now. Except for two things:
1. I get an error message every time it trys copying a sheet that is as follows:
"The name 'MAT' already exists. Click Yes to use that version of the name , or click No to rename the version of 'MAT' you're moving or copying"

2. All of the checkboxes from APF512MN to APF524MN only work halfway. They will add the new sheet and rename it but they wont add anything to the"CutList"

I have been over this code 100 times and maybe Im blind but I cant see where I went wrong. Im sure its a typo somewhere but I cant find it! so if someone can find my mistake it would be awesome!

Also if you're going through and you think hey he could do this in a much simpler way by all means PLEASE let me know ! Any way I can simplify is apprecated.


Things you may need to know:

I'm using excel 2013
All the global variables are stored in a module called: GlobalVars
All the code is stored in the code section of "MatForm"

To Run this as it is supposed to run:
1.Open the workbook,
2.Go to the "CutList Sheet"
3.Click the "CutList Generator" Button (orange button)
4. Go to the "NAAMS" Tab (ignore the rest they are for other purposes)
5. Go to the "Fence" Tab than the "MM" Tab
6. Check off some check boxes and enter random number values in the txtboxes beside them
7. Click "Add Parts" to see what it does and how it works.

Heres the workbook.
NAAMS FENCE JOB MAKER FOR EXCELFORUM.xlsm

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

The first part is not really an error - it's just Excel telling you that you are copying a sheet with a defined name. You can suppress that using:

Please Login or Register  to view this content.

The MN checkboxes work fine for me in that sample.