Congratulations on completing the Excel VBA course.
You now have the fundamental knowledge you need to write and execute VBA code to automate and enhance
your Excel files.
In this course we learned about what VBA is and how to use it.
We've covered the basics of VBA which included variables arrays and routines and we covered basic objects
in VBA while talking about file interactions which included the object hierarchy and the worksheet workbook
and table objects.
We cover the basic manipulators for math and string type variables as well as how to pass those variables
between routines as arguments.
We talked about loops with and with and if statements which are common concepts in all computer coding
we covered how to build and use forms to enhance your user interface.
And we talked about speeding up your code as well as debugging and testing your code to find and handle
errors.
Lastly we covered some more advanced topics like custom functions and events.
This all begs the question What can you do now moving forward.
The best thing you can do to develop your knowledge is to practice using it automate files you've already
built that you're already familiar with.
Ask yourself what aspects of your existing Excel files might have a cleaner user interface.
If you use a form or if you could simplify long and complicated formulas by creating a custom function
and of course always remember that nothing is impossible with excels VBA so you may be able to automate
things you couldn't before or build capabilities that you couldn't before.
Don't forget these reference sites as you go along in case you hit a bump in the road.
Microsoft's help site is great at explaining VBA functions and object types and Stack Overflow is a
community resource for answering specific questions or helping find code errors.
Of course there are hundreds of helpful sites and references so when in doubt you can always try googling
whatever it is you're having trouble with.
Thanks for checking out this Excel VBA course.
You are now ready to take your newfound knowledge back to your work or school or personal Excel files
to automate and enhance them.
Best of luck.