by Nate Moore | May 26, 2014 | Macros and VBA
Writing macros and code is great, but when you need to debug problems in your code, start by watching Excel Video 411. The challenge with finding problems in your macros and code is that they generally run so fast it’s hard to tell where the problems are. By choosing...
by Nate Moore | May 19, 2014 | Macros and VBA
Excel Video 410 gives you a behind the scenes look at what the Macro Recorder is doing in Visual Basic for Applications when it records a macro. Watch how I use Alt+F11 to open the Visual Basic Editor and follow along as I record a macro in Excel. If you want to learn...
by Nate Moore | May 12, 2014 | Macros and VBA
Looking for a Moore creative way to launch macros? Watch Excel Video 409 to learn how to attach macros to shapes and pictures in a spreadsheet. The trick is to design and format the shape or picture you want to launch the macro and then right-click. Choose Assign...
by Nate Moore | May 5, 2014 | Macros and VBA
Excel Video 408 shows you how to create a button to run a macro on your spreadsheet. Excel Video 407 added buttons to the Ribbon and the Quick Access Toolbar, but if you only want the macro to run on one spreadsheet, you may prefer to simply have a button to run the...
