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