One of the quickest way to learn VBA in Excel is:
if you know how to do what you want 'by hand' in Excel (clicking on cells, using menus, moving around, etc) - use the Macro Recorder and look at the code (Alt-F11)
I would strongly recommend the text book "An Introduction to Programming Using Visual Basic 5.0" ISBN : 0138758573
You can find it on ebay sometimes. Everything in this book also applies to VB6.
I appreciate the suggestions! I am an old timer with Crystal Reports, but many of the reports used in my new company are Excel using VB. I have figured out some of it but need a good foundation to understand what I'm doing. Maybe these suggestions will help!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.