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...
