How to Use Your Personal Macro Workbook
- Comments Off
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.
Working with Userforms Part 1: Hello World! Button
- Comments Off
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 […]
What Are You Looking for Help With?
As a follow up to the poll How Often Do You Use Excel Macros, to further lead the direction of Excel Hints, we asked you the question: Are you looking for more help with Macros or Formulas?
Macro tips on Excel Hints
- Comments Off
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 […]
Familiarizing With the Visual Basic Editor
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 […]