JasonC-VBA
New Member
- Joined
- Aug 30, 2011
- Messages
- 21
I have an “Equipment” worksheet contains about 300 rows listing pieces of equipment, quantities, prices, due dates and other miscellaneous items (15 columns total). Most of the quantities and due dates are calculated automatically via simple formulas. Cells with formulas are automatically shaded gray via conditional formatting checking a simple function:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
Function IsFormula(c)
IsFormula = c.HasFormula<o></o>
End Function
<o> </o>
This has worked fine for months.
<o> </o>
Recently I added a running subtotal and project cost change to the status bar. I use Worksheet_Change to call a subroutine that updates the status bar totals. This works fine on every worksheet except the equipment worksheet containing the conditional formatting. When quantities or prices are changed on this sheet the Worksheet_Change event is not called. When I delete the conditional formatting the Worksheet_Change event works and the subtotals update correctly.
<o> </o>
Is there a way for both to work simultaneously?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>Function IsFormula(c)
IsFormula = c.HasFormula<o
></o>End Function
<o
> </o>This has worked fine for months.
<o
> </o>Recently I added a running subtotal and project cost change to the status bar. I use Worksheet_Change to call a subroutine that updates the status bar totals. This works fine on every worksheet except the equipment worksheet containing the conditional formatting. When quantities or prices are changed on this sheet the Worksheet_Change event is not called. When I delete the conditional formatting the Worksheet_Change event works and the subtotals update correctly.
<o
> </o>Is there a way for both to work simultaneously?
