Hi,

"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.

--
vijay

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

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.