Having trouble using a nested IF with VBA msgbox

Hello,

I am looking to have my VBA code trigger a message box upon opening the file which asks the user if they'd like to clear certain cells. I want the "Yes" on the first question to trigger another message box asking them if they are sure they want to go through with it. I need the "Yes" on the second message box to clear the cells. Thank you for the help, here is my code:

Please Login or Register  to view this content.

Your code works just fine

I shortened the event trigger just to make it simpler, but turns out that was the issue. Here is my actual code with the actual ranges that need to be cleared. This is giving me the error of "Application-defined or object-defined error".

Please Login or Register  to view this content.

If you want to specify each range like that you are going to need to use the Union property. Very tedious but it will work

Please Login or Register  to view this content.

Another option would be to incorporate a looping structure if there is consistency amongst your columns. I have given you an example, up to you to make sure it works for your data set

Please Login or Register  to view this content.

Thank you very much. I used the first one since there isn't much consistency in the worksheet. Can you only loop if there aren't consistent columns or is there a way around that? Thanks again.

You can loop through each column but there needs to be a mechanism in place to tell the code which columns to apply the code to. This can be done many ways, but at this point it might be best just to work with the first option I showed you. In retrospect, we could have created an array of each column that you need the code applied then looped through the array. Next time.