VBA: Syntax part 2: Objects vs Data types and Declaring Variables

preview_player
Показать описание

For you to safely work with any objects or data types within VBA you'll need the fundamental lessons in this video. Excel will do plenty of guess work if you don't provide good structure to your coding, but I recommend you follow the concepts in this video closely to ensure that your code runs as you expect it to.

There's a tip at the end about removing objects from memory that is important for keeping excel from crashing unexpectedly!

For more info go to:
  1. Amber Sharpe
  2. VBA
  3. objects
  4. data types
  5. declaring variables
  6. string
Рекомендации по теме
Excel VBA Entry 0:10:16

Excel VBA Entry Form - Part 2 (Frames, Combo-Boxes, Add Items)

Excel VBA: Objects, 0:02:28

Excel VBA: Objects, Properties, Methods in Details | Part 2

Excel VBA language 0:06:22

Excel VBA language | Objects, Methods & Properties

How To Create 0:11:19

How To Create Vba Code Modules In Excel

Intro to Excel 0:07:02

Intro to Excel VBA - Writing VBA Code Pt. 2

Excel VBA Objects: 0:10:02

Excel VBA Objects: Shape Object (Part 1)

TUTORIAL VBA MACRO 0:16:32

TUTORIAL VBA MACRO EXCEL Part 2: Object (Application, Workbooks, Worksheet, Range)

05 - Excel 0:15:00

05 - Excel VBA Fundamentals - Working with Excel's Object Model and VBA

Bringing Power BI-Style 1:32:36

Bringing Power BI-Style Visualisations into Excel | Laura Szepesi

Excel VBA Objects: 0:06:56

Excel VBA Objects: Excel Object Model And Object Hierarchy

How VBA Objects 0:17:46

How VBA Objects Really Work in Memory

Excel VBA Introduction 0:21:16

Excel VBA Introduction Part 9 - Object Variables

VBA Objects Properties 0:07:29

VBA Objects Properties and Methods Explained with VBA Examples using Excel 2019

How to Work 0:19:01

How to Work With the Command Bar Object in VBA

Excel VBA Objects: 0:25:07

Excel VBA Objects: Worksheet Object

Excel VBA Online 0:06:21

Excel VBA Online Course - 4.2.2 Object Variable Scope

Excel VBA Forms 0:28:01

Excel VBA Forms Part 2 - Running and Navigating Forms

A must know 0:00:54

A must know Excel VBA Code 👨‍💻

Make Your VBA 0:16:34

Make Your VBA Code Run 1000 Times Faster (Part 2)

Excel Visual Basic 0:06:28

Excel Visual Basic (VBA) for Beginners - Part 2 of 4: Change Cell Values

Excel VBA Basics 0:09:40

Excel VBA Basics #2 - Using the Cells object with and without range object, named ranges

Learn How to 0:13:09

Learn How to Use Properties and Methods in Excel VBA Effectively

How to Declare 0:07:32

How to Declare (Dim) and Set VBA Variables (use data types correctly)

Excel VBA - 0:03:25

Excel VBA - Write a Simple Macro

Комментарии
Автор

I SEARCH FOR VBA EXPLANATION ALMOST 1 MONTHS ALREADY.. NOW I FOUND THIS CHANNEL!! 👑

KC_.
Автор

Thank you very much, I was really struggling to grasp VBA since it's my first shot at programming and I have no prior reference to go by. Really helpful.

gobertoangela
Автор

These 3 videos on VBA syntax (yeah, I watched the 3rd one already) are amazing. The knowledge that you can gain from YouTube is not always reliable - this is.

USSBARBEL
Автор

i was just wondering, the whole point of declaring variables is just for your reference? and making it nothing would just revert is back as if nothing happened?

MrDrewluna