Nov 29 2010

How to Use Your Personal Macro Workbook

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.

Sep 8 2009

Working with Userforms Part 1: Hello World! Button

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 […]

Apr 16 2009

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?

Oct 5 2007

Macro tips on Excel Hints

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 […]

Feb 5 2007

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 […]

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks