And you want this message to pop up automatically, right, Vijay? You don't
want the spreadsheet user to have to run the macro every time he makes a
change? Sounds to me as though you need either a Worksheet_Change macro
(which runs whenever a cell in the worksheet is changed "by the user or by an
external link") or possibly WorkbookBeforeClose, if you want it to run only
when the user closes the document.

--- "vijay" wrote:
"I'm working on a sheet were sheet 1 has the summary of all the sheets
from sheet 2 to sheet 32. I have to work on number of batches, in which
1 batch have an max count of 50. So I have given a countif function in cell
D2. saying that whenever there is "completed" in cell G10:G110 show me
the count of "Completed" in Cell "D2", as once I reach to the count of 50
I need to close that particular batch. So I have given similiar Countif
function in Cells as below: - D2,E2,F2,G2,H2,I2 and J2 on all the sheet
from sheet 2 to Sheet 32.

In Short what I want is a message box should pop up saying "Do you want
to Close the Batch" whenever there is a count showing as only 50 in the
Cells D2,E2,F2,G2,H2 and J2 on all the sheets from sheet 2 to Sheet 32
that I have in the workbook, except the sheet1 which has the summary
report.