Need to Have Macro Support More than 1 Line

[Jason Jang]

Hi, I'm fairly new to VB and am having trouble with my form.

I am creating an accessibility review template/worksheet for my staff which uses a userform and automatically inserts and deletes pictures. I've attached the worksheet I am working on. The problem is when I create a button and link it to the macro, is it is only good for that line. If I copy it to the next line, I have to create a brand new macro. If you look at the code I have had to write a macro for all five lines. I want to be able to get at least 100 lines worth. That is 100 macros.

Is there a way to have the userform come up for each row, but not have to be a custom macro for each line?

I have a similar problem with the inserting and deleting the picture. When you insert the picture, I have it named so that I can delete it afterwards, but now this is linked to the one picture. I can't add another picture to the other lines because the macro wants to delete the first picture.

Is there a way to insert and delete these pictures using one macro?

At this rate I would have 300 macros

Thanks,

Jason