Back to lesson
1. Assume you have the function shown below. Where could you call this function from?
A worksheet cell by typing =sCompany()
The VBA Immediate window by typing: =sCompany()
Excel's Macro dialog
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?
Nothing (the function will not recalculate)
Nothing, but the function will recalculate when the workbook is reopened
The function will update to show the new worksheet name
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