| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
User defined function detects font colour
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
User defined function detects font colour
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) "WeedOutSpammers" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
User defined function detects font colour
Useful, thank you. It would be a good product enhancement though
"Bob Phillips" wrote: 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) "WeedOutSpammers" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
User defined function detects font colour
Agree with that. It is certainly oft-asked.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "WeedOutSpammers" wrote in message ... Useful, thank you. It would be a good product enhancement though "Bob Phillips" wrote: 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) "WeedOutSpammers" wrote in message ... 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
User defined function detects font colour
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 "WeedOutSpammers" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color a result cell in a user defined function | Excel Discussion (Misc queries) | |||
| Creating my own user defined function help statements | Excel Worksheet Functions | |||
| User defined charts- font size too small | Charts and Charting in Excel | |||
| how to move user defined function | Excel Worksheet Functions | |||
| Function to return colour of formatted cell | Excel Worksheet Functions | |||
Linear Mode
