What is VBA in the context of Excel and what can it accomplish that formulas cannot?

Microsoft Excel Hard

Microsoft Excel — Hard

What is VBA in the context of Excel and what can it accomplish that formulas cannot?

Key points

  • VBA can automate tasks that formulas cannot
  • Custom functions can be created using VBA
  • VBA enables interaction with other Office applications
  • Declarative formulas have limitations that VBA overcomes

Ready to go further?

Related questions