Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic evaluation of custom worksheet function
Hi,
I've created a short custom function that returns TRUE or FALSE if one or more cells within the specified range is colored red. The function works correctly, but if the interior color of one of the specified cells ever changes, the function doesn't dynamically re-evaluate itself... I have to manually force the formula cell to evaluate the function by double clicking and hitting enter. Any ideas? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic evaluation of custom worksheet function
That's why you shouldn't base calculations on formats! Changing a format
doesn't trigger a calculation. I'm not real knowledgable about VBA but you can insert a line of code at the beginning of your UDF that makes it volatile: Application.Volatile This STILL will not cause it to recalculate when the format is changed but it will recalculate ANY time a sheet calculation takes place. I don't know why the experts don't discourage calculations based on color/format. Biff "Jim" wrote in message ... Hi, I've created a short custom function that returns TRUE or FALSE if one or more cells within the specified range is colored red. The function works correctly, but if the interior color of one of the specified cells ever changes, the function doesn't dynamically re-evaluate itself... I have to manually force the formula cell to evaluate the function by double clicking and hitting enter. Any ideas? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic updating of a rollup worksheet when a new worksheet is a | Excel Worksheet Functions | |||
Need help with custom function that deals with times | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel |