Published 2/2023MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 17.24 GB | Duration: 26h 22m

Excel VBA

What you'll learn

Programming in Excel from scratch

Implementing an automation in Excel

Creating application in Excel

Best programming techniques in Excel

Advanced programming techniques in Excel

Requirements

In this course, I will teach you how to program in excel using VBA code. You don’t need to have any programming experience to participate in this course as we will start from the total basics, explaining each step, and ending up on complex programming tasks.

To follow along with this course and Excel 2010, 2013, 2016, 2019 or Microsoft Office 365 is required

Description

This course is dedicated to everyone who wants to learn how to use VBA in Excel. You will learn how to create complex applications and perform automations in Excel environment.In this course we will start from total basics, so you don’t need any programming experience at all to participate and learn how to code in Excel.We will mostly focus on practical and just a little on theoretical aspect of programming in Excel. I will show you best programming techniques I have learnt myself.We will cover topics such as enabling developer section, recording the macro, reading the recorded code, code debugging, creating user interfaces (UI), creating applications, usage of classes and objects in excel VBA.This course is split into 6 sections in which we will discuss each of mentioned topics. We will use gained knowledge to create 3 applications in Excel.These applications will be Life Game, Minesweeper Game and Diet Application. Each of them will present different level of task complexity. By creating these applications, we will learn different project approaches and programming techniques.To each programming lesson there will be an attachment with excel file and code created in current lecture so it will be easier for you to follow along with the course and find bugs by comparing the code you have created, with the one from the course.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Recording Macro

Lecture 2 Setting up environment

Lecture 3 Recording Macro

Lecture 4 Data Types in Excel VBA

Lecture 5 Modules, Variables & Methods Declaration

Lecture 6 Reading recorded macro

Lecture 7 Modifying recorded macro

Lecture 8 Declaring variables

Section 3: Life Game

Lecture 9 Section Overview & introduction to algorithm

Lecture 10 Introduction to User Forms

Lecture 11 User Form controls

Lecture 12 User Form logic implementation

Lecture 13 Generate Field 1

Lecture 14 Generate Field 2

Lecture 15 Int positive limit for field generator

Lecture 16 Generate random population

Lecture 17 Generate 1 Life Cycle - read data

Lecture 18 Generate 1 Life Cycle - apply rules

Lecture 19 Generate 1 Life Cycle - count alive neighbours

Lecture 20 Generate 1 Life Cycle - investigate count alive neighbours

Lecture 21 Generate 1 Life Cycle - copy data from memory to excel

Section 4: Minesweeper Game

Lecture 22 Section overview & introduction

Lecture 23 Minesweeper UI Creating Game Panel

Lecture 24 Minesweeper UI adding modes and background sheets

Lecture 25 Adding global variables

Lecture 26 Generate Field

Lecture 27 Generate Field investigate recorded macro

Lecture 28 Generate Field - moving generated code

Lecture 29 Generate Field - read size from cells using global variables

Lecture 30 Generate mines 1

Lecture 31 Generate mines 2

Lecture 32 Generate mines 3 - speed up macro

Lecture 33 Calculate number of mines

Lecture 34 Reveal Fields - catching double click event 1

Lecture 35 Reveal Fields - catching double click event 2

Lecture 36 Reveal Fields - count score and win condition

Lecture 37 Reveal Fields - loosing condition

Lecture 38 Populate win-loose information

Lecture 39 Reveal zeros automatically

Lecture 40 Reveal zeros automatically - bug fix

Lecture 41 Right Mouse Button click catch - mark fields

Lecture 42 Right Mouse Button click - glitch clearing reveald field

Lecture 43 Statistics

Lecture 44 Delete Anti Cheat - Challenge

Lecture 45 Anti Cheat Solution

Lecture 46 Loose Won effect

Lecture 47 Hiding sheets - final

Section 5: Class Module & OOP

Lecture 48 Section overview & introduction

Lecture 49 OOP & Design Patterns

Lecture 50 Classes in Excel

Lecture 51 Class example, creating class

Lecture 52 Class Example, object creation

Lecture 53 Factory method overview

Lecture 54 Factory method implementation

Section 6: Diet Application

Lecture 55 Section overview & introduction

Lecture 56 Ingredient Class construction

Lecture 57 Ingredient Class Factory

Lecture 58 Meal Class construction

Lecture 59 Meal Class Factory

Lecture 60 Daily Meals Class construction

Lecture 61 Daily Meals Factory

Lecture 62 Meal Class Amend construction and Factory

Lecture 63 Weekly Diet Plan Class construction

Lecture 64 Weekly Diet Plan Factory

Lecture 65 Main View

Lecture 66 Ingredients View

Lecture 67 Ingredients View Modify New Buttons

Lecture 68 Meals View

Lecture 69 Meals View adding UI elements through code 1

Lecture 70 Meals View adding UI elements through code 2

Lecture 71 Meals View dynamically added UI element event handling

Lecture 72 Meals View moving ingredient rows

Lecture 73 Meals View Modify Button

Lecture 74 Weekly Diet View 1

Lecture 75 Weekly Diet View 2

Lecture 76 Weekly Diet dynamic UI generation 1

Lecture 77 Weekly Diet dynamic UI generation 2

Lecture 78 Weekly Diet dynamically added UI element event handling

Lecture 79 Weekly Diet Modify New buttons

Lecture 80 Diet Application File structure and storing data

Lecture 81 Ingredient View Adding New Ingredient 1

Lecture 82 Ingredient View Adding New Ingredient 2

Lecture 83 Ingredient View Adding New Ingredient 3

Lecture 84 Ingredient View Populate Ingredients in ComboBox

Lecture 85 Ingredient View load ingredient from ComboBox

Lecture 86 Meals View Adding New Meal 1

Lecture 87 Meals View Adding New Meal 2 - Check if Numeric Value

Lecture 88 Meals View Adding New Meal 3 - Check if Numeric Value in Dynamic elements

Lecture 89 Meals View Adding New Meal 4 - calculate Kcal 1

Lecture 90 Meals View Adding New Meal 5 - calculate Kcal 2

Lecture 91 Meals View Adding New Meal 6 - calculate Kcal 3

Lecture 92 Meals View Adding New Meal 7 - calculate Kcal 4 Dynamic elements

Lecture 93 Meals View Adding New Meal 8 - calculate Kcal 5 Dynamic elements - bug tracking

Lecture 94 Meals View Adding New Meal 9 - Save data 1

Lecture 95 Meals View Adding New Meal 10 - Save data 2

Lecture 96 Meals View Adding New Meal 11 - Save data 3

Lecture 97 Meals View Adding New Meal 12 - Save data 4

Lecture 98 Meals View Adding New Meal 13 - Save data 5

Lecture 99 Meals View Adding New Meal 14 - Save data 6

Lecture 100 Meals View - fixing errors

Lecture 101 Meals View Populate Meals in Combobox

Lecture 102 Meals View Load Meals to User Form 1

Lecture 103 Meals View Load Meals to User Form 2

Lecture 104 Meals View Load Meals to User Form 3

Lecture 105 Weekly Diet View Adding New Daily Meals 1

Lecture 106 Weekly Diet View Adding New Daily Meals 2 - dynamic combobox list

Lecture 107 Weekly Diet View Adding New Daily Meals 2 - dynamic combobox list - fixing bug

Lecture 108 Weekly Diet View Adding New Daily Meals 3 - calculate total nutrition for day

Lecture 109 Weekly Diet View Adding New Daily Meals 4 - week day comboboxes

Lecture 110 Weekly Diet View Adding New Daily Meals 5 - create diet plan object

Lecture 111 Weekly Diet View Adding New Daily Meals 6 - adding data to object 1

Lecture 112 Weekly Diet View Adding New Daily Meals 7 - adding data to object 2

Lecture 113 Weekly Diet View Adding New Daily Meals 8 - adding data to object 3

Lecture 114 Weekly Diet View Adding New Daily Meals 9 - adding data to object 4

Lecture 115 Weekly Diet View Adding New Daily Meals 10 - adding data to object 5

Lecture 116 Weekly Diet View Adding New Daily Meals 11 - adding data from dynamic elements 1

Lecture 117 Weekly Diet View Adding New Daily Meals 12 - adding data from dynamic elements 2

Lecture 118 Weekly Diet View Adding New Daily Meals 13 - display specific day data 1

Lecture 119 Weekly Diet View Adding New Daily Meals 14 - display specific day data 2

Lecture 120 Weekly Diet View Adding New Daily Meals 15 - remove item from list

Lecture 121 Weekly Diet View Adding New Daily Meals 16 - save meal plan 1

Lecture 122 Weekly Diet View Adding New Daily Meals 16 - save meal plan 2

Lecture 123 Weekly Diet View Load Weekly Diet Plans to Combo Box

Lecture 124 Weekly Diet View Load Weekly Diet Plan to memory 1

Lecture 125 Weekly Diet View Load Weekly Diet Plan to memory 2

Lecture 126 Weekly Diet View Load Weekly Diet Plan to memory 3

Lecture 127 Weekly Diet View Load Weekly Diet Plan to memory 4

Lecture 128 Weekly Diet View Load Daily Plan To UI 1

Lecture 129 Weekly Diet View Load Daily Plan To UI 2

Lecture 130 Weekly Diet View Load Daily Plan To UI 3

Lecture 131 Weekly Diet View Load Daily Plan To UI 4

Lecture 132 Weekly Diet View Load Daily Plan To UI 5

Lecture 133 Weekly Diet View Load Daily Plan To UI 6

Lecture 134 Weekly Diet View Generate Diet To Excel Worksheet 1

Lecture 135 Weekly Diet View Generate Diet To Excel Worksheet 2

Lecture 136 Weekly Diet View Generate Diet To Excel Worksheet 3

Lecture 137 Weekly Diet View Generate Diet To Excel Worksheet 4

Lecture 138 Weekly Diet View Generate Diet To Excel Worksheet 5

Lecture 139 Weekly Diet View Generate Diet To Excel Worksheet 6

Lecture 140 Weekly Diet View Generate Diet To Excel Worksheet 7

Lecture 141 Bug Fixes

This course is dedicated to everyone who wants to learn or improve programming skills in Excel VBA.

HomePage:

gfxtra__Excel_VBA_.part01.rar.html

gfxtra__Excel_VBA_.part02.rar.html

gfxtra__Excel_VBA_.part03.rar.html

gfxtra__Excel_VBA_.part04.rar.html

gfxtra__Excel_VBA_.part05.rar.html

gfxtra__Excel_VBA_.part06.rar.html

gfxtra__Excel_VBA_.part07.rar.html

gfxtra__Excel_VBA_.part08.rar.html

gfxtra__Excel_VBA_.part09.rar.html

gfxtra__Excel_VBA_.part10.rar.html

gfxtra__Excel_VBA_.part11.rar.html

gfxtra__Excel_VBA_.part12.rar.html

gfxtra__Excel_VBA_.part13.rar.html

gfxtra__Excel_VBA_.part14.rar.html

gfxtra__Excel_VBA_.part15.rar.html

gfxtra__Excel_VBA_.part16.rar.html

gfxtra__Excel_VBA_.part17.rar.html

gfxtra__Excel_VBA_.part18.rar.html