I created a custom function in vba but it does not update automatically like sum or other functions. The function gets numbers from another worksheet in the same workbook but when the numbers on the other worksheet change the cell with the function does not update automatically. Is there any special code that I need to have it update when the number changes on the other worksheet?