Tag Archives: Excel

How to set Microsoft Excel cell background color in VBA

Recently I have been working on a VBA project, so I will post some skills or tips I learned and used on Excel VBA program. Today I will share how to change the cell background color in the VBA module.

The property of background color is , and the color is used as Index format. So to setup a cell (row ID: 1, column ID: 12) in Red background color is the below:

Worksheets(1).Cells(1,12).Interior.ColorIndex = 3 ‘change the background color to RED

And you can find more color index in the rest of my post. Continue reading

How to export Outlook Distribution List to .csv file format

[Updated on 2008-12] This post can be treated as one of the “how-to” serials on Outlook tips.

I know we can export Contacts from Outlook directly into .csv (Comma Delimited) files, but not the same case in Distribution list. That is understandable since Distribution lists are not creating any new Contacts, just grouping these existing contacts.

But I need to export these Contacts into different .csv files based on the Distribution Lists I already created before. So I had to do extra steps to make the export happen.

Step 1: Save Distribution List as Text file

Continue reading