VBA JETPACK Introduction to VBA www trumpexcel com
VBA JETPACK Introduction to VBA © www. trumpexcel. com
VBA…. What? • VBA stands for Visual Basic for Applications. • VBA is a programming language used for Microsoft Office Applications. It can be used to automate tasks within Excel (and other applications). • With VBA, you can do a lot of things that you can not otherwise do in Excel. © www. trumpexcel. com
VBA at your service…. What can you do with it? • Automate a series of tasks (and run it with a single click or shortcut). • Create functions that does not exist. • Create Add-ins. • Create Applications. © www. trumpexcel. com
VBA Building Blocks • Sub / Procedure • Functions • Events • Objects • Variables © www. trumpexcel. com
Object Oriented Programming © www. trumpexcel. com
Object Oriented Programming • • • Name - Sherlock Holmes House No. - 221 B Street - Baker Street City - London Country - England © www. trumpexcel. com
Object Oriented Programming © www. trumpexcel. com
Object Oriented Programming © www. trumpexcel. com
Object Oriented Programming © www. trumpexcel. com
Object Oriented Programming © www. trumpexcel. com
Object Oriented Programming © www. trumpexcel. com
Object Oriented Programming Apply red background colour to Cell A 1, in the Worksheet (Sheet 1), in the Workbook (Test. xlsx) in Excel © www. trumpexcel. com
Object Oriented Programming Excel © www. trumpexcel. com
Object Oriented Programming WORKBOOK © www. trumpexcel. com
Object Oriented Programming WORKSHEET © www. trumpexcel. com
Object Oriented Programming RANGE (A 1) © www. trumpexcel. com
Object Oriented Programming COLOR © www. trumpexcel. com
- Slides: 17