VBA Programming: Working with Objects and Collections
This video addresses the intricacies of objects, collections, and their relationship in the world of VBA programming. Objects like forms, pages, or frames contain collections, and among the most commonly encountered are controls. These controls, often found on a form, offer a myriad of functionalities and can be manipulated using VBA code. The video delves deep into how to effectively address and change the values of these controls through various loop methods, especially in scenarios where end-users might have specific accessibility needs. You will witness live demonstrations on how to dynamically change the appearance of controls using 'For Next', 'For Each', and 'With' loop syntaxes in VBA, and see the significance of each in achieving distinct visual outcomes.
Keywords:
VBA, objects, collections, controls, loops, For Next, For Each, With syntax, accessibility, font change, color change, dynamic appearance, form controls
See my other channels:
Current news on the economy and economic concepts:
https://www.youtube.com/@doctorecon
Current thoughts on leadership topics:
https://www.youtube.com/@pharosleadership
Blockchain and Cryptocurrency News:
https://www.youtube.com/@pharosblockchain
-
LIVE
Vigilant News Network
8 hours agoMedia Blackout: 10 News Stories They Chose Not to Tell You - Episode 28
1,401 watching -
13:07
Evenout
8 hours agoStealing Jordan 1 OG Then Re-Appearing With a Different Shoes Twin Prank!
29.6K7 -
1:20:26
Winston Marshall
1 day agoUNCOVERED: Legal System Weaponised - Trump, Hunter, Bannon & Biden | The Winston Marshall Show #020
63.7K138 -
16:09
Chicks in the Office
9 hours agoOur Top 12 Songs On Repeat This Week - Music You Can't Miss
50.8K31 -
2:23:05
Gigi Young
1 day agoLecture: The Mystery of Death
42.2K5 -
1:01:15
The Dan Bongino Show
12 hours agoSUNDAY SPECIAL with Mike Benz, Scott Presler, Julie Kelly and Jim Verdi - 06/23/2024
204K571 -
31:41
Standpoint with Gabe Groisman
12 hours agoEp. 32. Libs of TikTok. Chaya Raichik
80.5K61 -
35:24
Squaring The Circle w/ Randall Carlson
1 day ago#009 Are Sea Levels REALLY Rising? Pt 2 - Squaring the Circle: A Randall Carlson Podcast
107K67 -
14:23
Freakin' Reviews
1 day agoPan Wars! $90 Caraway vs $8 Martha Stewart!
84.1K25 -
4:21
ParisDemers
1 day agoScientific Trick That Increases Your Testosterone 400% In 7 Days!
93.9K36