For any of the repeating tasks that you do through macros, Excel provides a way to have those commonly used actions always available to you. Instead of copying the macros you use frequently to every workbook, Excel gives you use of a Personal Macro Workbook.
Over the next few posts we will look at how to build a userform and put it to good use. Using a userform will provide additional functionality in your project that using the spreadsheet alone may not provide. One way to give your project that customized polished look, may be to incorporate the use of […]
Lately all the updates I have been adding to excel hints have been related to the formulas that are incorporated into Microsoft Excel. While I still probably have hundreds of formulas that need added to this site, I am going to begin adding tips on how to use the Macro capabilities for Excel. Macros in […]
In this post, I’m am going to start off with just showing you the parts of a basic macro and how you can get to the editor. To see this feature for your self the first thing you want to do is record a macro. Try typing some text in a cell, maybe some copying and […]