ExcelBanter - Format Event Trigger (XL2002)

Thanks for the confirmation as that's what I sort of thought based on the
fact that I couldn't even find another event other than remotely
SheetChange, but that's on the workbook level and if Change event didn't do
it, then surely, SheetChange wouldn't either.

Here's what I wanted to have happen:

When the user puts in a fill color to the cells that contains quantities
that's either considered to be Scheduled (with no fill color) or Made (with
the fill color), it would be triggered and run only the necessary
calculations.

Here's what I have done in response to this limitation of Excel:

I have put in a MsgBox function to allow the user to determine if the
quantity is a scheduled quantity or made quantity, though using a Yes/No is
not the best way, but it's about the only way I know of given the code is
within an Event code (Change Event) rather than a generalized macro. Some
portions of the code is centralized within the file, but the actions are
still based on the worksheet that triggered the event, which case,
SheetChange Event may have been the better way to go with it, but before I
make that decision, I still need to check with one of the users to see what
other things will be in the workbook.

Would you know of a better way of how to achieve this and still require
minimal work on the user part?

Example:

---------------------
|1st shift|2nd shift|
---------------------
| 200 | 300 |
---------------------

Above Example is the part that deals with the user putting in either
scheduled or made quantities.

One such reason for using code instead of formulaes is cause of how
notorious Excel is with it's redundant calculations, though Excel 2K is 3
times faster than XL97 processing wise, but that's still slow. Have not
noticed a significant difference between XL2K and XLXP with regards to
calculation processes or times.

User plans on having at least 53 weekly worksheets within the file

Information is to be linked between 3 different workbooks, which could
potentially run into one of the Excel external link issues as documented,
thus another reason why to use VBA instead of formulaes.

--
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000

"Tom Ogilvy" wrote in message
...
No, no event is triggered.

--
Regards,
Tom Ogilvy

"Ronald Dodge" wrote in message
...
Is there an event that gets triggered when once does a format change
such
as
the fill color of a cell?

I have tried the Change event on the worksheet level, and it does not
get
triggered.

--
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000