VBA sub procedures can perform lots of tasks and there are many ways to execute those functions in Microsoft Excel.

Adding "Save" Button in Excel If you want to add a VBA save as button in Excel, you can do so using the "Developer" tab in the ribbon menu.

What is InputBox? VBA’s InputBox function is one of the most helpful functions you’ll use. It displays a dialog box and waits for the user to enter content and then click a button to continue.