UDFs - Improve to automatically update when input changes

HI,

I'm dipping my toe into the world of UDFs and developed two really simply ones to create an index at the start of my workbook.

One function returns a sheet name based on the index number of the sheet, and the 2nd function returns the value of a cell in a given sheet.

It works when i pass the inputs to the function, but if i change the inputs i have to recalculate the function manually. I have read a couple of work arounds to get the workbook to recalculate, but as i'm just learning i'd rather build the functions correctly in the first place with best practice rather than get into fudges & bad habits!

Can someone point out what i am doing wrong and what i should be doing? Thanks for any help!

Please Login or Register  to view this content.

You can put this at the top after sub function

Please Login or Register  to view this content.

That's worked thanks!

Is it standard practice that if you want a UDF to automatically update whenever any of the inputs change that you need to set that property at the start of the code?

I am not 100% sure. I think I have seen functions work with out volatile, but can not remember how and why.

Rory!
Thank you for clarification!

thank you both for the input, i'll take those points under advisement!

Thanks!