by Nate Moore | Nov 3, 2014 | Macros and VBA
In Excel Video 434 we’ll work through how to capture user input from Message Boxes. Notice how the syntax is slightly different when we need the user’s answer. We define a variable as equal to the Message Box and the Message Box function now needs parentheses. The...
by Nate Moore | Oct 27, 2014 | Macros and VBA
Excel Video 433 takes Message Boxes a step further by customizing the message buttons. The trick is that instead of using a default like vbOKCancel or vbInformation, try using a number instead. Here’s the URL for the page I reference in the video:...
by Nate Moore | Oct 20, 2014 | Macros and VBA
Excel Video 432 is the first of three videos on how to use Message Boxes in Excel. Today we’ll build a basic message box with the text inside the box, the button choices inside the box, and the title of the box. There are a whole list of choices for buttons. We’ll...
by Nate Moore | Oct 13, 2014 | Macros and VBA
Excel Video 431 wraps up our discussion of looping with an example. We’re going to replace all of the underscore characters with spaces in a set of 6 cells. The first thing you’ll say is, “Nate, I can do that much easier with Find and Replace.” No question. To keep...
by Nate Moore | Oct 6, 2014 | Macros and VBA
If you watched Excel Video 429, Excel Video 430 will make a lot of sense as an extension of Do loops. The Do Until Loop has the condition at the top of the loop so the loop may never run, as in our first example. If you put the condition at the bottom of the loop, as...
by Nate Moore | Sep 29, 2014 | Macros and VBA
Excel Video 429 introduces another way to loop through data with Do While Loops and Do Loops While. The difference between those two types of loops is where the While condition is. A Do While Loop may never run if the condition is never met, but a Do Loop While will...
