Back to lesson
1. Assume you have the function shown below. Where could you call this function from?
The VBA Immediate window by typing: =sCompany()
Excel's Macro dialog
A worksheet cell by typing =sCompany()
2. You call the function below from a worksheet cell and it correctly returns the name of the worksheet. What will happen when the worksheet is renamed?
The function will update to show the new worksheet name
Nothing (the function will not recalculate)
Nothing, but the function will recalculate when the workbook is reopened
3. If your UDF does not recalculate when the inputs change, what code do you need to add to it?
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement