Given: cells A1:A10 has a value/text.

Formula written in A11....=if(countif(A1:A10)>0;"yes";"no"). *This is basically an "alert" to say that all cells have been filled.

I would like to write this format into VBA, except in place of "no", I would like a pop-up message informing me that information is missing.

Any help would be greatly appreciated.