Macro for value matching the cell

[vijay]

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/com...78b0ed1&dg=microsoft.public.excel.programming

 

[Bob Bridges]

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.