I have a macro that runs through a list and checks to see if something exists. If it doesn't exist, the macro pops up a message box to alert the user and asks if they would like the macro to insert the missing data. Everything works, but I realized if there is a lot of missing data, the popup box is kind of annoying. Is there a way to do a "Yes to All" message box or to automatically bypass the message box once it's inside the loop? Here is my chopped up code:
Please Login or Register to view this content.
Bookmarks