|
| |
| Download Archives - VBA and VB.Net Tutorials, Education and Programming Services | |
|
|
Tag Archives: Download Excel VBA Chr() FunctionIn this article I will explain about the Chr() function. The Chr() function is a very useful function when working with strings and Excel columns. Generally speaking, numbers and characters are mapped. Meaning that each character is mapped to a number and vice versa. For 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 Excel VBA, Underline Font StyleThis article explains the different types of underlines possible to apply to cells and ranges. It also provides the associated VBA code for adding the underline. For examples using these codes please see: Excel VBA Set Underline (Sample Code + Download) Excel VBA Get Underline Excel VBA, Font SizeIn this article I will explain how you can change the size of the font for a cell or range in Excel using VBA. I’ve also provided an example on how you can retrieve the size of the font used in a cell or range. Excel Functions and Formulas Sample #1, Split Strings Based on DelimiterIn this article I will provide an example on how you could split a string based on a delimiter character using excel formulas and functions. You can download the workbook for this article here. Jump To: Function Used in this Example Summary Implementation Step 1, Indice Column Excel VBA Print_UniqueTo_Column(), Sample Code + DownloadIn this article I will explain the function Print_UniqueTo_Column(). Print_UniqueTo_Column() is a function I’ve written in VBA for Excel. You can download the code and file related to this article here. Jump To: Input Parameters Example As Input it receives the location of a column of data and Excel Functions and Formulas, Adding (Concatenating) TextAdding (Concatenating) text in cells can be done using the “&” symbol. In the example below cell D2 adds (concatenates) the strings in cells A2, B2 and C2: Result: By modifying the values in the cells A2, B2 or C2 the value in D2 is automatically updated: Excel Functions and Formulas Get Substring, MID(), LEFT(), RIGHT()In this article I will explain the functions MID(), LEFT(), RIGHT(). The main purpose of these functions is to return a certain number of characters (substring) from a text. You can download the workbook related to this article here. Jump To: Syntax LEFT RIGHT MID Drop Down List Creator (Sample Code and Download)The following code is a function I’ve written which creates drop down lists. The drop down lists are created using data validation. It is assumed that there is a column with the drop down list values on one of the sheets. Another feature of this Excel Pivot Tables (Example + Download)In this article I will explain the PivotTable feature of excel along with 2 examples. You can download the file related to this article here. Jump To: What is a PivotTable and What is it Used for? Step 1: Creating an Empty PivotTable Step 2:
More To Explore
|
