Prevent Workbook from closing when value from one cell is missing & another cell is not

**RXcel** · 12-13-2017, 01:33 AM

Hi,

So I have been working to create a vba program that will prevent the user from closing the workbook if the first cell is not empty and the cell below is, or the first cell is empty but the cell below is not. If both cell are empty or both cell are not empty, then the workbook will save and close.

What I want to do is to apply this for the entire row or at least a range if possible. Checking each of the column. If you have any idea please help. Thank you.

Here is the code that I have been working on and trying to tweak to apply to entire row.

Please Login or Register  to view this content.

**skywriter** · 12-13-2017, 02:45 AM

This code will check A1 against A2, B1 against B2 etc over to column G.

If A1 and A2 both either have data or both don't have data it will continue to B1 and B2 and run the same check.

If at any time one has data and the other is blank you get a message saying there is a problem with those two cells.

Please Login or Register  to view this content.

**RXcel** · 12-13-2017, 03:28 AM

Hi Skywriter,

I have applied your code and got this:

Please Login or Register  to view this content.

When I ran this code, I don't get an error message when I just fill in A1 cell. I put this in Sheet1. Do you know what is happening?

Thank you

**skywriter** · 12-13-2017, 11:15 AM

Are you going to tell us what the error is?

How are you calling the code?

**RXcel** · 12-13-2017, 09:34 PM

My apology, I meant the message box when I have one cell empty and the next row cell filled. I am not sure what you mean by calling the code but I was hoping that it would automatically occur when I close the Excel Application

**skywriter** · 12-13-2017, 11:06 PM

Sub Test was just a made up title.

The body of the code was meant to be put into the workbook before close event of the thisworkbook class module.

The reason I asked how you were calling it is because you added an argument to the first line of the code that I wrote, which means you have to call the code and pass in a value for cancel.

I put the cancel = true line in there under the assumption you would use it in the workbook event code as you did with the code you originally posted, it was just to give you an idea of where to put that line.

**RXcel** · 12-14-2017, 12:45 AM

It worked!!! Thank you Skywriter for all the help you provided for my dilemma with my code. .

**skywriter** · 12-14-2017, 01:59 PM

My pleasure, thanks for the feedback.

Prevent Workbook from closing when value from one cell is missing & another cell is not

LinkBack

Thread Tools

Rate This Thread

Display

Prevent Workbook from closing when value from one cell is missing & another cell is not

Re: Prevent Workbook from closing when value from one cell is missing & another cell is no

Re: Prevent Workbook from closing when value from one cell is missing & another cell is no

Re: Prevent Workbook from closing when value from one cell is missing & another cell is no

Re: Prevent Workbook from closing when value from one cell is missing & another cell is no

Re: Prevent Workbook from closing when value from one cell is missing & another cell is no

Re: Prevent Workbook from closing when value from one cell is missing & another cell is no

Re: Prevent Workbook from closing when value from one cell is missing & another cell is no

Thread Information

Users Browsing this Thread

Similar Threads

Require Entry in Cell /Prevent COUNT if Missing

[SOLVED] Prevent a workbook from closing if any cells are unlocked

[SOLVED] Prevent user from closing worksheet if cell is blank

[SOLVED] Prevent closing of a workbook if condition is met - code included

Macro to prevent closing of workbook depending on certain criteria

[SOLVED] Prevent closing workbook unless specific cells have data

Prevent closing of one workbook when two are open

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions