Microsoft Excel VBA - Solving Complex Problems Using Basics
- Description
- Curriculum
- FAQ
- Reviews
Microsoft Excel Professional Date Picker Series – Part 2
Microsoft Excel VBA – Solving Complex Problems Using Basics, is designed to make you a skilled and faster VBA coder.
In this course, you’re going to learn VBA concepts that will boost your coding skill and give you the abilities to solve complex problems that are thrown at you. I will teach you the art of writing a complex code piece-by-piece using basic techniques.
After this course, you must be a skilled and fluent coder, knowing clearly how to manipulate complex Excel VBA problems. The skills you will get here are usable across all areas of VBA programming.
So, after completing this course, all you will need to do next is to add new distinct knowledge on specific areas of VBA programming e.g.
-
how to work with a Multi-page User Form,
-
How to work with an editable User Form,
-
Understanding the User Form Environments,
-
Understanding the worksheet environments,
-
working with databases,
-
authentication & authorisation in Excel
-
etc.
However, studying all these new areas will be very simple because you already have the coding skill cemented in your mind, and that skill is appliable across all areas of VBA learning. Many people make a mistake and jump to study these areas first before they learn the art of writing a VBA code. As a result, they suffer confusion, and everything they learn fails to add up.
In this course, I’m going to put you on the right track in your Excel VBA career.
Now, this is part 2 in the professional date picker series. In part 1 of the date picker series, I mentioned that VBA coding becomes complicated only when the commands you pass to an object must first be derived through calculation. Well, we have come to that complicated part. This is the part in the date picker series where you must become an expert coder. So, this course will add a top layer on the foundation we built in part 1 of the date picker series. I will teach you how to solve complex problems using basics, and you will learn how to write a complex code step by step.
If this is what you are looking for, please sign up for the course.
Thank you
-
8Source File (Starting point)Text lesson
At the beginning of this module, your file must look like this one. If you don't have your own file from part 1 of the date picker series, please download this one and use it as your starting point.
-
9Source File - The Date Display Defaults - Nested LoopsText lesson
At the end of this module, your file must look like this one. Please download and compare it with what you have produced.
-
10Source File - Populating the date pickerText lesson
At the end of this module, your file must look like this one. Please download and compare it with what you have produced.
-
11Source File - Enabling the Top NavigationText lesson
At the end of this module, your file must look like this one. Please download and compare it with what you have produced.
-
12Date and Time Picker Files - Download Completed VersionText lesson
-
13Using RGB function to set coloursVideo lesson
-
14Working with Constants - Procedure LevelVideo lesson
-
15The downside of a procedure-level constantVideo lesson
-
16Working with Constants - Module LevelVideo lesson
-
17Adding more constantsVideo lesson
-
18Working with Constants - EnumerationVideo lesson
-
19Arranging Display - Separation of ConcernsVideo lesson
-
20Configuring the Days SectionVideo lesson
-
21Eliminating RedundancyVideo lesson
-
22The Looping TechniqueVideo lesson
-
23Accessing the Controls CollectionVideo lesson
-
24Indirect Referencing of LabelsVideo lesson
-
25Dynamically Updating the Left PositionVideo lesson
-
26Testing the Left PositionVideo lesson
-
27Coding the Days CaptionsVideo lesson
-
34IntroductionVideo lesson
-
35Updating the Footer DisplayVideo lesson
-
36Using the Format() functionVideo lesson
-
37Updating the Header Display (Year)Video lesson
-
38Updating the Header Display (Month)Video lesson
-
39Populating Date Display - First DayVideo lesson
-
40Populating Date Display - Week OneVideo lesson
-
41Updating the remaining weeksVideo lesson
-
42Determining Day OneVideo lesson
-
43Testing Day OneVideo lesson
-
44Determining the Starting DateVideo lesson
-
45Displaying Current Month DatesVideo lesson
-
46Considering the Changing WeeksVideo lesson
-
47Distinguishing Current Month DatesVideo lesson
-
48Marking Today's DateVideo lesson
-
49IntroductionVideo lesson
-
50Configuring the Prior Year ButtonVideo lesson
-
51Configuring the Next Year ButtonVideo lesson
-
52Configuring the Prior Month ButtonVideo lesson
-
53Accessing the Previous YearVideo lesson
-
54Introducing FunctionsVideo lesson
-
55Function and Variable ComparisonVideo lesson
-
56Storage - Let the Variable do its jobVideo lesson
-
57Configuring the Next Month ButtonVideo lesson
-
58Updating the Dates DisplayVideo lesson
-
59Updating the Dates Display (Testing)Video lesson
-
60Fixing the Today MarkerVideo lesson
-
61Refreshing the Date PickerVideo lesson
-
62Activating the rest of the top navigation buttonsVideo lesson
-
63Separation of ConcernsVideo lesson
-
64Summary & ConclusionVideo lesson
External Links May Contain Affiliate Links read more