MsgBox vbYesNo with several VBA's

Hello,

I have several working VBA codes.
First I want to work this code working when "Yes" is selected in a vbYesNo MsgBox:

Please Login or Register  to view this content.

When this VBA is done I want a MsgBox:

Please Login or Register  to view this content.

When I click "Ok" in this MsgBox it should be great if (I3:I200; K3:K200; M3:M200 and O3;O200) will be cleared of all values.

Thanks

First I want to work this code working when "Yes" is selected in a vbYesNo MsgBox:

Does this do what you want?

Please Login or Register  to view this content.

When I click "Ok" in this MsgBox it should be great if (I3:I200; K3:K200; M3:M200 and O3;O200) will be cleared of all values.

Please Login or Register  to view this content.

partially.

I have a commandbutton when I click this button I want to see the MsgBox vbYesNo (text: "Would you like to keep your inputs?")
When I click yes the first macro should run.

When this is done (if its possible) I automaticaly want to receive a MsgBox (with the result of my second macro).

Afterwards I want the given range back cleared so everything is ready for the following input.

I hope you can uderstand my question.

I have a commandbutton when I click this button I want to see the MsgBox vbYesNo

Then the code should not be in the Worksheet_Change event, but in the CommandButton<name>_Click event. There is no 'Target' anymore however, so I've changed 'Target' to 'Selection'.

Please Login or Register  to view this content.

The code is giving a few problems.

I receive the MsgBox's but the codes will not run. The values in columns D and Q does not appaer and the ClearContents is giving an error.

Error: Object variable or With block variable not set

Can you upload the spreadsheet?

Here is the spreadsheet

I see my mistake - there needs to be another For/Next loop after the msgbox. Try this:

Please Login or Register  to view this content.

Yes indeed the ClearContents works.

But the first part still doesn't work. The part were columns "D" and "R" will count the values in columns "I" till "O"