Getters and Setters in VBA

  Рет қаралды 7,323

Jennifer Garth

Jennifer Garth

Жыл бұрын

In this video, we look at how getters and setters work in VBA.
In order to understand how getters and setters work, we'll step through the ones we added to the cat class we created in my "Creating Classes in VBA" video ( • Creating Classes in VBA ).
_____________________________________________________________________________________
If you appreciate my content, please support this channel by donating on my website: sayrhymes.com/donate/
#JenniferGarthVBA #vbatutorial

Пікірлер: 6
@weibinren92
@weibinren92 Жыл бұрын
Hi, at 8:56, the content of the rngCatName Setter shouldn't be "Set prngCatName = rngCatNameArg"? And the content of the Getter should be "Set rngCatName = prngCatName"
@Jennifer_Garth
@Jennifer_Garth Жыл бұрын
Yes, you are correct! Thank you for pointing this out. At 9:51, the code is corrected, which is why it worked when I ran the code. When I was editing the video, I must not have noticed that that code is wrong and then corrected with no explanation. I will see if there is any way for me to edit the video on KZfaq to add a note about the error. I will also create a new video discussing this issue and use it as an opportunity to discuss getters and setters a little more and talk a little bit about debugging. But for now, I'll just pin your comment.
@jmathew6988
@jmathew6988 Жыл бұрын
This is gold. Thank you!
@philhamilton6926
@philhamilton6926 Жыл бұрын
Good clear explanation. Thank you.
@Maxseven777
@Maxseven777 Жыл бұрын
I think the three properties should be changed by Microsoft to Get, SetObj, SetVal, instead of Get, Set and Let. I find the "Let" term to be confusing. Just saying 😁
@fahadshaheen2373
@fahadshaheen2373 6 ай бұрын
sorry Jennifer , but the explanation is really confusing especially with this unnoticed mistake you have made .
Convert Existing VBA Code into a Class
25:55
Jennifer Garth
Рет қаралды 9 М.
Custom Enumerations in VBA
10:32
Jennifer Garth
Рет қаралды 2,8 М.
Survival skills: A great idea with duct tape #survival #lifehacks #camping
00:27
Please be kind🙏
00:34
ISSEI / いっせい
Рет қаралды 185 МЛН
ИРИНА КАЙРАТОВНА - АЙДАХАР (БЕКА) [MV]
02:51
ГОСТ ENTERTAINMENT
Рет қаралды 7 МЛН
raw php basic class 02
29:28
Future Computer Training Institute
Рет қаралды 2
How to Use Nested Dictionaries in VBA
8:58
Excel Macro Mastery
Рет қаралды 14 М.
Learn How to Use Properties and Methods in Excel VBA Effectively
13:09
Working with Multiple Classes in VBA
1:11:47
Jennifer Garth
Рет қаралды 5 М.
How to use Class Modules with the VBA Dictionary
14:30
Excel Macro Mastery
Рет қаралды 49 М.
Creating Classes in VBA
10:19
Jennifer Garth
Рет қаралды 17 М.
Introduction to Variables
9:17
Jennifer Garth
Рет қаралды 594
Class Modules in VBA: Made Super Simple
17:43
Excel Macro Mastery
Рет қаралды 30 М.
5 Tips For Object-Oriented Programming Done Well - In Python
16:08
Introduction to Userforms in VBA
26:10
Jennifer Garth
Рет қаралды 403
Неразрушаемый смартфон
1:00
Status
Рет қаралды 2 МЛН
cute mini iphone
0:34
승비니 Seungbini
Рет қаралды 5 МЛН
Lid hologram 3d
0:32
LEDG
Рет қаралды 10 МЛН