Whenever you need to work with very many cells in Excel, check or manipulate cell values, it can considerably speed up your code to use arrays instead of working directly with the cells.

( Here're a few examples to show how it works )

( Getting Started with Arrays in Visual Basic for Applications )

VBA offers the functions GetSetting, SaveSetting, GetAllSettings and DeleteSetting for reading and writing the Windows Registry. (For detailed info see the Microsoft VBA help for these functions or look at the MSDN)

But unfortunately you can't access the entire registry, only the path HKEY_CURRENT_USER\Software\VB and VBA Program Settings\. So you ( Read more... )

If you want the user to input a date in a Userform, you could of course just use a Textbox. But you'd have to write a lot of code to check whether the user put in a correct date, in the correct format, within the allowed timeframe, etc. Using calendar controls is the easier way, it looks nicer and you don't have to do all these checks by yourself ( Read more... )

So in your Userform, you want to give the user the choice between different options?
( About Radiobuttons and Checkboxes in Userforms... )

Because I never find it when I need it - A way to fill a multi-column listbox (or combobox) with VBA

( Read more... )

Another useful code snippet for VBA:
The following function displays a dialog box that enables the user to select a folder and then returns a string containing the selected folder's path in a string.

( Read more... )

Talking about colors...

A very good reference for colors in the color palette and how to color things in Excel is this siteSomething one often needs is a color picker. Want to change the color of something, but leave it to the user, which color exactly. Then you need a tool that lets the user pick a color ( Read more... )

Sometimes it'd be useful if one could resize their own userforms at runtime. To enable such functionality, it needs a bit of ( coding work... )

So you want to run some code when clicking in a cell, and you want to run something else when right clicking into this cell?

( Then do the following... )