Top Articles

A VBA Progress Bar for Excel and Other Microsoft Apps.

alainbryden10/13/2009, 12:00 AM

Keeping the user informed is important If you have written some VBA code for Excel (or Word, or Access), and it takes a long time to execute, it is important to keep the user informed that the code is progressing. Psychologically, it can also have

Topic: Microsoft Excel Spreadsheet SoftwareTags: Excel, VBA, Automation, Progress Bar, Cancel Button, Time Elapsed

Views: 12894Comments: 19

Six Reasons Why Your VLOOKUP or HLOOKUP Formula Does Not Work

matthewspatrick03/09/2010, 12:00 AM

by Patrick G. Matthews Introduction VLOOKUP is a tremendously useful function that allows you to "fetch" data from a specified rectangular range (the "lookup table"); this range can be on the same worksheet, a different worksheet in the sa

Topic: Microsoft Excel Spreadsheet SoftwareTags: Microsoft, Excel, VLOOKUP, HLOOKUP, function, formula, #N/A, N/A, error

Views: 12724Comments: 35

Playing with Time Conversion in Excel

saurabh72611/20/2008, 12:00 AM

Lot of times in Excel we have to do quick time conversion that is...The time is given in Time format which is -->12:00:00 and we need to convert it into a number format that is -->12 A quick multipication of same by 24 will convert it to the

Topic: Microsoft Excel Spreadsheet SoftwareTags: Excel Time Conversion

Views: 10393Comments: 7

Excel Tips & Tricks: The Camera Tool

harfang10/17/2009, 12:00 AM

Introduction Back in the years when I was teaching Excel 4 (yes, version 4, when .xls meant "worksheet" and not "workbook"), I had a couple of recreational exercises to use when the class was getting tired, after the afternoon break. One of them

Topic: Microsoft Excel Spreadsheet SoftwareTags: Excel Camera Picture Link layout dashboard report traffic light semaphore

Views: 9723Comments: 55

Eliminating duplicate data with Duplicate Master V2

brettdj12/17/2009, 12:00 AM

Introduction - The Problem Many people use or inherit spreadsheets built with database functionality.  A frequent problem with such spreadsheets is duplicate data, either of entire records, or in specific fields.  Duplicate data in your spreadshe

Topic: Microsoft Excel Spreadsheet SoftwareTags: excel, duplicates, vba, regular expressions, fuzzy match, addin, unique, brettdj

Views: 7573Comments: 100

Using Variant Arrays in Excel VBA for Large Scale Data Manipulation

brettdj03/17/2010, 12:00 AM

Introduction One of the most common VBA techniques is the use of a For .. Next loop to iterate through all the cells in a range.  The syntax is straightforward and easily applied.  Unfortunately, for large data sets it can also be the programming e

Topic: Microsoft Excel Spreadsheet SoftwareTags: Variant Arrays VBA, For Next Loops, Code optimisation, leading zero replacement, regular expression

Views: 7543Comments: 34

Option to open excel 2007 documents in a new instance

alainbryden06/22/2009, 12:00 AM

Problems we all know excel has Many people are tired of the way excel workbooks are affected by every other workbook you have opened. When you calculate one, they all calculate.  Excel acts as though they are inter-dependent when they really aren't

Topic: Microsoft Excel Spreadsheet SoftwareTags: Excel, Excel 2007, Windows XP, Shell

Views: 7041Comments: 8

How to dynamically control form List Box controls in Excel.

alainbryden06/16/2009, 12:00 AM

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab

Topic: Microsoft Excel Spreadsheet SoftwareTags: Excel VBA, Excel Controls, Excel 2007, Excel 2003, ListBox, ListBoxes

Views: 6537Comments: 20

Fixed Rate Loan Amortization Schedule with Optional Extra Principal Payments

matthewspatrick06/28/2010, 12:00 AM

Introduction Using Microsoft Excel to create a fixed rate loan amortization schedule is a very common task: probably just about every skilled Excel user who has ever taken out a mortgage has either created such a schedule him/herself or downloade

Topic: Microsoft Excel Spreadsheet SoftwareTags: mortgage amortization, loan amortization, amortization, loan, mortgage, Excel, VBA, VB6, interest, principal, PMT, PPMT, IPMT

Views: 5921Comments: 28
Loading Advertisement...

Top MS Excel Experts

  1. dlmille

    1,351,499

    Genius

    10,680 points yesterday

    Profile
    Rank: Genius

  2. ssaqibh

    542,555

    Sage

    0 points yesterday

    Profile
    Rank: Genius

  3. rorya

    381,757

    Wizard

    4,225 points yesterday

    Profile
    Rank: Savant

  4. imnorie

    334,112

    Wizard

    0 points yesterday

    Profile
    Rank: Genius

  5. teylyn

    282,850

    Guru

    20 points yesterday

    Profile
    Rank: Genius

  6. barryhoudini

    280,460

    Guru

    0 points yesterday

    Profile
    Rank: Genius

  7. redmondb

    235,511

    Guru

    2,000 points yesterday

    Profile
    Rank: Sage

  8. matthewspatrick

    230,947

    Guru

    2,010 points yesterday

    Profile
    Rank: Savant

  9. byundt

    197,840

    Guru

    820 points yesterday

    Profile
    Rank: Savant

  10. zorvek

    144,626

    Master

    0 points yesterday

    Profile
    Rank: Savant

  11. StephenJR

    136,537

    Master

    0 points yesterday

    Profile
    Rank: Genius

  12. nutsch

    117,005

    Master

    0 points yesterday

    Profile
    Rank: Genius

  13. gowflow

    110,036

    Master

    0 points yesterday

    Profile
    Rank: Sage

  14. MartinLiss

    107,333

    Master

    0 points yesterday

    Profile
    Rank: Wizard

  15. GlennLRay

    95,652

    Master

    0 points yesterday

    Profile
    Rank: Guru

  16. robhenson

    90,250

    Master

    0 points yesterday

    Profile
    Rank: Sage

  17. ScriptAddict

    88,470

    Master

    0 points yesterday

    Profile
    Rank: Guru

  18. kgerb

    85,022

    Master

    0 points yesterday

    Profile
    Rank: Wizard

  19. aikimark

    84,456

    Master

    3,310 points yesterday

    Profile
    Rank: Genius

  20. andrewssd3

    80,242

    Master

    0 points yesterday

    Profile
    Rank: Wizard

  21. Wiesje

    69,918

    Master

    0 points yesterday

    Profile
    Rank: Master

  22. Shanan212

    66,418

    Master

    0 points yesterday

    Profile
    Rank: Master

  23. krishnakrkc

    59,548

    Master

    0 points yesterday

    Profile
    Rank: Wizard

  24. Michael74

    54,744

    Master

    0 points yesterday

    Profile
    Rank: Wizard

  25. regmigrant

    51,070

    Master

    0 points yesterday

    Profile
    Rank: Guru

Hall Of Fame