pedrumj

[pedrumj]

Excel VBA, Italic Font

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.

Read more ...

[pedrumj]

Excel VBA, Bold Font Style, (Font.Bold & Font.FontStyle)

Excel VBA, Bold Font Style, (Font.Bold & Font.FontStyle)

In this article I will explain how you can use VBA to change the bold font property of cells and ranges. I have also provided an example on how to check if a cells has the bold font property on or off.

Read more ...

[pedrumj]

Excel VBA, Set Cell Alignment Properties (Sample Code + Download)

Excel VBA, Set Cell Alignment Properties (Sample Code + Download):

In this article I've provided a sample code that will set the alignment properties of the cells in the first row using VBA. The user selects different alignment properties using the drop down lists provided. The program then updates the alignment properties of the cells in row 1

Read more ...

[pedrumj]

Excel VBA, Get Cell Alignment Properties (Sample Code + Download)

Excel VBA, Get Cell Alignment Properties (Sample Code + Download):

In this article I've provided a sample code that will get the alignment properties of the cells in the first row. The way it works is that whenever the user presses the run button the alignment properties of the cells B1 to D1 will be displayed in the rows below

Read more ....

[pedrumj]

Excel VBA, Reading Order

Excel VBA, Reading Order:

The article provides the required syntax for changing the reading order to cells in Excel:

1- Right to Left 2- Left to Right 3- Context

Read more ...

[pedrumj]

Excel VBA, Merge Cells

Excel VBA, Merge Cells:

In this article I will explain how you can use VBA to merge cells in Excel. I have also provided two sample codes.

Read more ...

[pedrumj]

Excel VBA, Shrink To Fit On/Off

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 range.

Read more ...

[pedrumj]

Excel VBA, Shrink To Fit On/Off

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 range.

Read more ...

[pedrumj]

Excel VBA, Wrap Text On/Off

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 if the current status of the wrap text property for a cell or range.

Read more ...

[pedrumj]

Excel VBA, Orientation (Alignment)

Excel VBA, Orientation (Alignment):

In this article I will explain how you can change the orientation of the content in cells. I have also provided several sample codes.

Read more ...

[pedrumj]

Excel VBA, Set Vertical Alignment (Sample Code)

Excel VBA, Set Vertical Alignment (Sample Code):

In this article I will provide an example on how to set the vertical alignment of cells using VBA. The user selects the vertical alignment from a set of drop down lists. The selected vertical alignment will be applied to the cell below the drop down list.

Read more ...

[pedrumj]

Excel VBA, Get Vertical Alignment (Sample Code)

Excel VBA, Get Vertical Alignment (Sample Code): In this article I will provide an example on how to find cells with a specific vertical alignment

Read more ...

[pedrumj]

Excel VBA, Get Horizontal Alignment (Sample Code)

Excel VBA, Get Horizontal Alignment (Sample Code):

In this article I will provide an example on how to find cells with a specific horizontal alignment. The user selects the desired horizontal alignment to find from a drop down list.

#Excel, #VBA, #Formatting, #Alignment, #HorizontalAlignment, #SampleCode,

Read more ...

[pedrumj]

Excel VBA, Set Horizontal Alignment, (Sample Code)

Excel VBA, Set Horizontal Alignment, (Sample Code):

In this article I will provide an example on how to set the horizontal alignment of cells using VBA. The user selects the horizontal alignment from a set of drop down lists. The selected horizontal alignment will be applied to the cell adjacent to the drop down list.

Read more ...

[pedrumj]

Excel VBA, Vertical Alignment:

Excel VBA, Vertical Alignment:

In this article I will explain the different vertical alignment formattings applicable to cells and ranges. I have also provided the VBA code required to apply them.

Read more ...

[pedrumj]

Excel VBA, Horizontal Alignment:

Excel VBA, Horizontal Alignment:

In this article I will explain the different horizontal formattings applicable to cells. I have also provided the VBA code required to apply different horizontal alignment to cells and ranges.

http://wp.me/p4la8z-nK

Read more ...

[pedrumj]

Excel VBA, Text File to Columns:

Excel VBA, Text File to Columns:

In this article I will explain how you can read the values in a text file and print them in columns in Excel

Read more ...