Microsoft Excel Basic Macros
Nonfiction, Computers, Application Software, Spreadsheets, Financial Applications
| Author: | Diane Griffiths | ISBN: | 9781370360536 |
| Publisher: | Diane Griffiths | Publication: | October 25, 2016 |
| Imprint: | Smashwords Edition | Language: | English |
| Author: | Diane Griffiths |
| ISBN: | 9781370360536 |
| Publisher: | Diane Griffiths |
| Publication: | October 25, 2016 |
| Imprint: | Smashwords Edition |
| Language: | English |
I want to give you some of the VBA basics which will help you to understand, read and use VBA code. I will give you some examples of how to create and run simple but useful code which you can implement immediately; you need no prior knowledge of programming, just a sound understanding of Excel.
VBA is a hugely powerful and complex environment. I want to give you the tools and confidence to do some basic coding to help you automate tasks. We will work with simple clear code. What I don’t do in this ebook is make you a VBA expert – nor do I encourage you to become one unless that’s something you have a deep desire to be. If you do want to be a VBA expert, then this ebook may give you some good foundations and code to get you going – but you’re going to need much more.
The ebook is split into bit-sized chunks. We start with some VBA foundations and write our first procedure. Then we move onto a bit more terminology and some useful one-liners in order to get you familiar with the code. The main bulk of the ebook is simple but useful VBA code which you can test or implement straight-away. I purposefully don’t give you a workbook with this ebook. The best way to learn code is to write it from scratch - I promise! We only work with simple code so it is quick to recreate. Finally I show you how to record and tweak a macro and then leave you with some hints and tips which will help you on your journey.
I want to give you some of the VBA basics which will help you to understand, read and use VBA code. I will give you some examples of how to create and run simple but useful code which you can implement immediately; you need no prior knowledge of programming, just a sound understanding of Excel.
VBA is a hugely powerful and complex environment. I want to give you the tools and confidence to do some basic coding to help you automate tasks. We will work with simple clear code. What I don’t do in this ebook is make you a VBA expert – nor do I encourage you to become one unless that’s something you have a deep desire to be. If you do want to be a VBA expert, then this ebook may give you some good foundations and code to get you going – but you’re going to need much more.
The ebook is split into bit-sized chunks. We start with some VBA foundations and write our first procedure. Then we move onto a bit more terminology and some useful one-liners in order to get you familiar with the code. The main bulk of the ebook is simple but useful VBA code which you can test or implement straight-away. I purposefully don’t give you a workbook with this ebook. The best way to learn code is to write it from scratch - I promise! We only work with simple code so it is quick to recreate. Finally I show you how to record and tweak a macro and then leave you with some hints and tips which will help you on your journey.
