
Macros & VBA:Advanced Playlist
Excel Video 432 Message Boxes Part 1
Excel Video 432 is the first of three videos on how to use Message Boxes in Excel. Today we’ll build a...
Excel Video 433 Message Boxes Part 2
Excel Video 433 takes Message Boxes a step further by customizing the message buttons. The trick is that...
Excel Video 434 Message Boxes Part 3
In Excel Video 434 we’ll work through how to capture user input from Message Boxes. Notice how the syntax...
Excel Video 435 If Statements
Adding If statements makes your code much more powerful. I’ll show you how to start using If statements...
Excel Video 436 Else and ElseIf
You can add more power to your If statements by using Else and ElseIf. Excel Video 436 has an example of...
Excel Video 437 More Complex If Statements
The pre-authorization example gets even more precise in Excel Video 437, the last Excel Video about If. ...
Excel Video 438 Case Statements
Excel Video 438 introduces case statements, which are a more concise and easier to read way to express...
Excel Video 439 Custom Functions Part 1
Excel Video 439 puts several of the things we’ve learned over the past Excel Videos together to build a...