Need help to pop up the mesgbox on null cells

Hi guys,

I need your help to show up the mesgbox on null blanks. Like for example i have 10 rows and 10 columns and a button which checks for validation now whenever i press that button it will check all the 10 rows and 10 columns that there would be no blank cell in between if it found any cell blank, it will pop up the error message.

I am thinking in 2 ways:

1) As if one column is filled so we can check the whole bunch of columns next to each other till the end.
2) we can check for the whole filled sheet that either if they are empty of not.

I am new in VBA, Kindly help me in this scenorio.

Thanks in Advance i attached the file already so you guys can have a look at it.

Maybe:

Please Login or Register  to view this content.

Hi John,

Thats work fine but it searches on the whole work sheet and i wanted for specific columns (A,B,D,F) so it will only search for filled cells with respect to row C.

I'm not understanding you. Do you want it to search on Column C only? Then msgbox if empy cell found? Or Columns (A,B,D,F) also?

HI Jhon,

let me explain you again i just want to search for the specific columns and rows either they have any blank cell or not?

like A,B,C and D when i press the search button it will search on A and B if it found any null cell it will pop up a message.

Maybe:

Please Login or Register  to view this content.

HI,

Thats working but its going for an Infinite loop checking every column and i need to check only the columns which are filled based on any one of the column.

I tested it on your sample and it checked Columns A,B,C,D & F to the last filled row.

Its running for me but it will be going for every row in the sheet ?

Originally Posted by abdullahsikandar

Its running for me but it will be going for every row in the sheet ?

It checks the Columns Specified from row 2 to Last filled row of the activesheet? Would you prefer something else?

id date name age city
123 01/02/2014 tom 25 london
234 03/02/2014 fred 26
this is acceptable? 345 05/02/2014 bill 27 leeds
456 07/02/2014 harry 28
567 09/02/2014 david 29 glasgow




on-screen message

id date name age city 4 fields need to be filled in
01/02/2014 tom 25 london
234 fred 26 1 id's
this is as filled in 345 05/02/2014 27 leeds 1 dates
456 07/02/2014 harry 1 names
567 09/02/2014 david 29 glasgow 1 ages

ID Name age
1 Ab 2 Result would be whenever i press the button it will day row 3 is missing and stop until the user press the button again. right now it will search for the whole worksheet.
2 CC 4
eD
3 4