Category Archives: Excel VBA Function

Changing Microsoft Excel Status Bar

Posted on September 10, 2008 by Admin

Maybe for some reason we want to change our Microsoft Excel Status Bar, then this simple vba function will do the work for us. The end result will look like this: Ok, to do it, put this following code in … Continue reading →

Posted in Excel VBA Function | Tagged , , , | 6 Comments

Handy VBA To Calculate Person Age

Posted on September 10, 2008 by Admin

This handy VBA procedure is just to show you how we can calculate and display someone Age. To do this, of course we need to know their date of birth first, then simply using datediff and mod vba functions we … Continue reading →

Posted in Excel VBA Function | Tagged , , | 13 Comments

Getting Cell Reference With Input Box

Posted on September 9, 2008 by Admin

We can get an input from user using Input Box, but we also can use the Input Box to get the address of cell reference in Microsoft Excel. Using simple Excel VBA procedure below we can ask user to select … Continue reading →

Posted in Excel VBA Function | Tagged , , , , , , , | 158 Comments

How To Find the Last Row That Contain Data in Excel?

Posted on June 17, 2008 by Admin

UPDATE June 13, 2008: Another alternative way to find the last row with data : Function LastRow() As Long Dim ix As Long ix = ActiveSheet.UsedRange.Row – 1 + ActiveSheet.UsedRange.Rows.Count LastRow = ix End Function I did a simple test, … Continue reading →

Posted in Excel VBA Function | Tagged , , , , , , , , , , , , , , , | 27 Comments

How to ceiling a decimal number in Excel?

Posted on June 16, 2008 by Admin

Ceiling, or changing a specific decimal number into become its upper number, for example if we ceiling 3.25 we will got 4, or if we ceiling 2.75 then we will got 3 as a result. To get a result like … Continue reading →

Posted in Excel VBA Function | Tagged , , , , , | 5 Comments