ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Data validation and application.volatile (https://www.excelbanter.com/excel-programming/333634-data-validation-application-volatile.html)

GSchwint

Data validation and application.volatile
 
I have created a couple of custom functions where I want my custom function
to calculate even though a cell it references has not been directly edited. I
use application.volatile to accomplish that, this also allows the function to
calculate prior to a worksheet change event, which is also something that I
want.

However, the application.volatile causes problems with other code I have;
specifically the code assigned to a button that references a cell where a
choice has been made using a data validation list. The code will not execute.
Any ideas as to what is causing this to happen? Or, is there a different way
to use application.volatile?

George


All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com