In this chapter we explored the VBA module and some of the things you can do with VBA to customize Dynamics GP. We now know the components of the VBA application and how to use the VBA Editor. We have worked through the objects in the Dynamics GP object module and have used several of their properties, methods, and events. We know that you can create new user forms with VBA and attach code that will interact with Dynamics windows and reports.
Our projects included adding a new button for navigation to the Vendor Credit Summary window and using an existing Dynamics GP object to add a Go To button to the Vendor Maintenance window. We walked through how to create, save, retrieve, and remove data from the DUOS table.
We also know how to deploy our VBA customizations along with some issues to keep in mind when creating and importing package files.
In the next chapter we will learn how to create robust customizations without writing a single line of code.