Duplicating a form with dialog box prompt

[Cboggie]

Hello!

I have a sheet that acts like a form to request a part. When you pull up the sheet, you will see one spot to fill out. If you want more, you select the dropdown and select 1,2,3.

As you'll see, i am just copy/pasting a form from another sheet, to populate the new forms.

In the Attachment field, i have some code that will allow the user to browse their computer and select a file which copies the filepath.

My problem is, I want to be able to let the user add more forms as needed. The attachment field becomes a problem as it is linked to a named range.

I was wondering if there is another way I should be doing this. I want to avoid repeating the same code tons of times. My idea about copy/pasting from another sheet to get the form is probably not going to work.

The idea is that when they send the sheet, it will pick up all the attachments as well.


Any suggestion would be helpful.

When you open the file, click MRO
Requisition Form2.xlsm