Tag Archives: Sample

No Thumbnail

Excel VBA, Wrap Text On/Off

In this article I will explain how you can use VBA to modify the wrap text property of a cell or range. I will also explain how you can use VBA to check the current status of the wrap text property for a cell or

No Thumbnail

Excel VBA Border Colors

One of the things you probably want to modify when working with borders in VBA for Excel is the border color. Previously I’ve explained about colors in the article VBA Excel Colors. Therefore I’m assuming readers are familiar with the basic concept of working with

No Thumbnail

Excel VBA, Get Border Properties

In this article I will explain how you can check if a cell has a border or not using VBA for Excel. I have also explained how you can get the different border properties using VBA. Jump To: Example 1, Check If Border Exists Example

No Thumbnail

Excel VBA, Shrink To Fit On/Off

In this article I will explain how you can use VBA to modify the shrink to fit property of a cell or range. I will also explain how you can use VBA to check the current status of the shrink to fit property of a cell or

No Thumbnail

Excel, Custom Date Formatting

Custom formatting, what is it? When working with Excel there may be times that you want to display a date. For example lets say you want to display the date January, 3rd 1988. In the figure below all the cells are showing the same date: The

No Thumbnail

Excel VBA, Font Name

In this article I will explain how you can change the font (name) used in a cell or range. I’ve also provided a sample code which gets the current font (name) used in a cell or range. You can download the code and file used

No Thumbnail

Excel VBA, Italic Font

In this article I will explain how you can use VBA to change the italic font property of cells and ranges. I have also provided an example on how to check if a cells has the italic font property on or off. Jump To: Basics Example 1,

No Thumbnail

Excel VBA, Create Border

In this article I will explain how you can make basic borders using VBA for Excel. Each range of cells can accept up to 8 different types of borders: Left edge (xlEdgeLeft) Top edge (xlEdgeTop) Bottom edge (xlEdgeBottom) Right edge (xlEdgeRight) Inside vertical (xlInsideVertical) Inside horizontal (xlInsideHorizontal) Diagonal down