Automatic Macro Stop Solved

Question

Hello,

I am working on VBA Excel. How can I make a macro stop automatically as soon as a message appears?
Indeed, I created a message ("Attention") that displays automatically only if a certain cell is empty, and I would like the macro to stop as soon as this message appears.
What should I write in VBA?
Help help!! Thanks

Configuration: Windows 2010/ Internet Explorer 7.0

ccm81 · Accepted Answer

Hello   after the msgbox  Exit Sub   have a good continuation

PHILOU10120 · Answer

Hello

You can add a dialog box to stop the macro to allow for correcting the empty cell

If MsgBox("Warning, correct the empty cell!!!", vbYesNo, "") = vbNo Then
Exit Sub
End If

Or you can place this in a cell that you will name "empty_cell_check" with a formula that returns true when the cell is empty

Set myRange = Worksheets("sheet").Range("empty_cell_check")
If myRange <> 1 Then
If MsgBox("You must enter information?", vbYes, "") = vbYes Then
Exit Sub
End If

It's up to you to decide what works best for your case.

ouistitlilie · Answer

I had indeed placed the exit sub, but not in the right place, that's why it wasn't working!! Thank you for your help!!

Automatic Macro Stop

3 réponses

Texture issues in enshrouded

Canon mb5350 - cartridge replacement impossible

Football manager (club management game)

Select next line csh foreach

Win32 kamso then rootkit detection

Win32:spyware-gen [trj] detected by avast

Unknown video error on the freebox player

Make it or break it

How to open a cbr file

Please log in with manager privileges.