by Allen Wyatt
(last updated March 14, 2015)
Many of the tips used in ExcelTips rely upon macros in order to run. Some readers may not know how to enter a macro from scratch in Excel. There are actually two ways you can create macros. First you can record a macro, which is appropriate when you want to record a series of steps you perform quite often. The second method of creating a macro, writing one from scratch, is much more powerful. To create a macro from scratch, follow these steps:
If you are still using Excel 95, the easiest way to create a macro from scratch is to first record a "dummy" macro, and then edit that macro to create your final "from scratch" macro.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2712) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
When you have multiple workbooks open at the same time, Excel allows you to easily switch between those workbooks. How you do ...Discover More
It is often helpful to get user input within a macro. Here's a quick way to present some options and get the user's response.Discover More
Make your macros too long, and Excel may just refuse to run them at all. This tip explains what the limit is for macros, and ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.