User defined function detects font colour

[Guest]

However, when the font colour is changed the worksheet does not recalculate.
Is there a way a recalculate can be forced on a format change? If the cell
is edited (or go into edit mode but do not change anything) then return is
pressed then everything works fine.

Who has a solution or is this just a free suggestion to Microsoft which
would simply add another dimension to the Worksheet for applications like
schedule creation for more than one supplier.

 

[Bob Phillips]

Colour change does not trigger any sort of recalculation.

You could add Application.Volatile to the start of the UDF, but this will
only recalculate when something else on the worksheet forces a
recalculation, such as another function being affect, or a hard recalculate,
Alt-F9.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Useful, thank you. It would be a good product enhancement though

 

[Bob Phillips]

Agree with that. It is certainly oft-asked.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Charles Williams]

A calculate event is not triggered by a format change BUT

conditional formats get executed by every screen refresh done on the part of
the screen they are formatting, and you can use UDFs in conditional format
conditions ...

regards
Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com