Tag Archives: Download

No Thumbnail

VBA Get Characters Unicode Value

I have created a VBA program that returns the unicode value associate with characters. The VBA code has been written inside a word document. Upon opening the word document a user form will display: By copying characters into the text box, their unicode value will be displayed

No Thumbnail

Excel Formulas and Function, Finding Text Within Another Text, Find()

The function FIND() searches for a specific text expression inside another text and returns the first index which the text was found. You can download the workbook related to this article here. Jump To: Syntax Example 1 Example 2 Syntax: =FIND(Text_to_Find, Text_to_Search_in, Starting_Index) Text_to_Find: The

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

Create Invoice/Bill Using VLOOKUP (Step by Step Tutorial)

In this article I will provide a step by step tutorial to explain how you can create an Invoice using VLOOKUP. I’ve explained the basics of using VLOOKUP in VLOOKUP, Excel Functions so I’m assuming you are familiar with the function. You can also download the complete Invoice file here. Jump To:

No Thumbnail

Excel, MATCH() function

In this article I will explain the MATCH() function in Excel. This function searches a 1 dimensional range for a target value. If the value is found the index of the value in the range is returned. You can download the file related to this

No Thumbnail

Excel COUNT() Function

In this article I will explain the count function. The COUNT() function returns the number of cells in a range which have numeric values in them. You can download the workbook for this article here. Jump To: Syntex Example 1, Get Row Count Example 2,

No Thumbnail

Excel VBA, Bold Font

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. Jump To: Basics