Macros and VBA can accomplish many of the same goals. When is it advantageous to use VBA?
What will be an ideal response?
When would it be advantageous to use macros?
VBA has a wider array of options, settings, and actions than Macros, such as allowing for a File Dialog box on importing. When these advanced or additional capabilities are not needed, then macros are many times simpler and quicker.
Computer Science & Information Technology
You might also like to view...
When an Excel spreadsheet is selected in a slide and the Excel Ribbon is displayed, pressing ________ will cause the formulas in the spreadsheet to recalculate if they do not recalculate automatically
A) F4 B) F1 C) F7 D) F9
Computer Science & Information Technology
What is the rate at which a biometric device rejects valid subjects?
a. FAR b. FRR c. CER d. CDC
Computer Science & Information Technology