IF data not complete, exit sub

Hello All,

My database building macro is working fine, but the users are not filling in all the information that would make my database complete.
I am trying to put some checking in at the start of the macro that would notify the user that they need to add more information in order for the entry to be made into the database.

My first few attempts look like this:

Please Login or Register  to view this content.

As you can see, I'm trying to test if the count of cells with data in ColV is less than the cells filled in, in ColB. This is my way of determining that the user has not filled in the supplier name for each item that they are wishing to enter.

At the moment, when i test the macro it does not exit sub when the condition i am trying to test for is met.

It's probably worth noting that I will be testing for the not only ColV, but also F,G,H,K,L,W as well - if there is a way to do all of these checks in one statement then i'd accept that, even if it means that the error message is generic

Hi,

The way I always do this sanity checking to ensure that all data has been entered is to use a single named cell in Excel, call it "Check" if you like.

Then for every item that needs to have been completed, in the Check Cell I put stuff like

Formula:

Please Login or Register  to view this content.

The idea being that when all relevant cells and conditions have been met the Check cell will be zero. Then your macro can simply read the Check Cell and proceed accordingly.

i.e.

Please Login or Register  to view this content.

You can build on this idea. For instance if say all of a column of values must be completed you can use say an =INDEX(MATCH()) pair of functions to find the first description which has not been included and read the result of that function into a message box tp tell the user which is the first item that has not been entered.

I find this approach far easier that using VBA and it's much easier to create functions to test the stuff you're trying to trap.

Thanks for such a quick response.

I will absolutely use a checksum cell and get my VBA to look for that. I'm currently kicking myself for not thinking of that in the first place!

Simple, yet elegant

Glad to have helped and thanks for the rep.