VBA MsgBox pop up required based on two criteria.

Hi Folks,

I currently have a MsgBox that appears when cells in column T contains the word "Switch". If it does then the MsgBox prompts the user to make some manual changes.

Please Login or Register  to view this content.

I need this manual step as the user needs to insert cash figures in column D.

This morning the user ignored the prompt and clicked yes when they should have clicked no.

If they click yes the macro continues along it merry way doing all sorts of calculations.

I am looking for some code that, if the user clicked yes the macro would continue (as it usually does) but the first task after clicking on "Yes" would be to look at column T for the word "Purchase" and if corresponding cell in column G contains the word "REDS" then bring up another MsgBox reprimanding the user for not changing the cell in column G from "REDS" to "SUBS". When they click OK it would Exit Sub. They would then make changes and run the macro again. Hopefully with everything corrected this time allowing the full macro to finish.

I appreciate there could be some functionality to make sure that if column T contain the word "Purchase" that the corresponding cell in column G could be changed to "SUBS" automatically but things aren't quite as straightforward as I have laid out above.

Sorry if the above is not clear and thanks as always for any help.

I think maybe I'm giving information overload.

I basically need a MsgBox to pop up based on the contents of two columns rather than one. I can currently search a column to check for a word which brings up the message.

I need the code to look at one column for a word (in this case "Purchase") and check the cell in a corresponding column for another word (In this case "REDS") if both the criteria are met then a MsgBox pops up. So if it checked column A and found the word "Purchase" in cell A12 then it would look to see of B12 contained the word "REDS". If B12 did contain the word "REDS" then a MsgBox pops up, otherwise the macro would continue.

Thanks Mumps1,

The VBA code for the whole macro is about 75 pages long if pasted into a word document and would contain a lot of confidential data.

I do acknowledge your concerns regarding pasting into an existing macro but I would be testing it first and keeping a back up of my existing macro.

If you were able to come up with some code I would be grateful.

Thanks

Thanks Mumps1,

That worked an absolute treat.