Hello Excel Experts!
We make heavy use of a user-defined function in conditional formatting in our applications.
We are trying to determine if this slows down the program in the same way that UDFs in cells do. So far, we tested by putting a breakpoint by the function to see when it gets called, but the breakpoint is never hit. (If we comment out the function, then there is an error, though.)
Does anyone know if using a UDF in this way slows down the application and/ or if there is any way to test?
Thank you!
We make heavy use of a user-defined function in conditional formatting in our applications.
We are trying to determine if this slows down the program in the same way that UDFs in cells do. So far, we tested by putting a breakpoint by the function to see when it gets called, but the breakpoint is never hit. (If we comment out the function, then there is an error, though.)
Does anyone know if using a UDF in this way slows down the application and/ or if there is any way to test?
Thank you!