Need to run macros depending on msgbox button clicked

**rosshkerr** · 02-29-2012, 08:07 PM

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?

**Richard Buttrey** · 02-29-2012, 08:11 PM

Hi,

Immediately after the message box which warns that data is missing enter the instruction:

Please Login or Register  to view this content.

**Grace14** · 02-29-2012, 08:23 PM

Hi,

I wish to know how to make the message Box that able to click whether to enable or able the macro

**Richard Buttrey** · 02-29-2012, 08:47 PM

Hi your original post implied you already have a message box within a macro. You said:

but at the moment the copy macro still runs

and indeed the title says 'need to run macros depending on...'

You now appear to be implying that you don't have any code at all.

Is that correct. If so please upload your workbook. There's no point in us guessing what it looks like if you want us to create a specific macro.

Regards

**rosshkerr** · 02-29-2012, 08:54 PM

Hi Richard

the reply above wasn't from me, but was from grace14! I would gladly upload the work book but I haven't figured out how to do that yet.

**rosshkerr** · 02-29-2012, 09:01 PM

I have code to check for and empty cell

Please Login or Register  to view this content.

and I have a message box to run this

Please Login or Register  to view this content.

and another message box to inform the user data is missing

Please Login or Register  to view this content.

I need to 'join these up' but also, if there is no data missing I want to run another macro that copies the data somewhere else.

**Grace14** · 02-29-2012, 09:11 PM

I'm Grace and sorry about not putting my name in the post.

Is there any way to make the mgs box?

**rosshkerr** · 02-29-2012, 09:16 PM

Aha. Think that's it

Dashboard.xlsm

**Richard Buttrey** · 03-01-2012, 06:07 AM

@grace14

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.