Using macros in Excel requires knowledge of Visual Basic for Applications (VBA). In this video lesson you will get an introduction to how macros work within Excel and how to build them. The video lesson includes the following topics:
- Setting up Excel workbooks to use Macros & VBA (filetype, menu and security settings).
- How to record a macro and edit recorded VBA code.
- How to write custom macro including InputBox and MsgBox functions.
- How to assign buttons and shortcuts to macros.
Make sure to download the Visual Basic Examples workbook here to follow along.
Dear Ben,
I just wanted to say thank you very much for all of your time and effort that went into making these excellent tutorials. I was recently made redundant and have used your videos to improve my skills and therefore my marketability.
Thank you very much from London, UK!
Warmest regards,
Jennifer
Hey Jennifer,
I’m so happy to hear that the site has been able to help you so much. I’m sure you’re right about it increasing your marketability in terms of a new job.
It’s amazing how important it is to have someone with deep Excel knowledge on the team.
Keep up the good work!
Cheers,
Ben
Thanks, Ben! As someone who’s hard-coded user-driven analysis tools in other environments, I really appreciate you covering InputBox. Looking forward to the next VBA tutorials!
Pingback: A Complete Introduction to Excel | MBAx.me
Ben,
Thank You very much for posting this free tutorials, very helpfull.
Excellent introduction
yes it is excellent
I just found this through Reddit and I’m quite grateful. A clear and concise first lesson.
This is excellent, I look forward to a more in depth look at VBA