I need to run a macro from a message box. If the user clicks yes it runs a macro to check if all data in the column has been entered. If all cells contain data a macro runs copying the data to another sheet. If an empty cell is found the user gets another message box telling them data is missing. When they click OK the macro should stop, but at the moment the copy macro still runs. Anyone got any ideas?