Case studies in problem solving with Microsoft Excel and VBA

Excel Tips

Create a Self-Adjusting Range

Top 10 List With a Consolidated Other Category

The Excel IF function

Dynamic Text in a Shape

Banded Rows

03-01 Conditional Color of Shapes

PowerPivot and Conditional Color of Shapes

03-02 Harvey Balls

Generate All Permutations

Array Formulas

Tips - Exotic

Property procedures in standard modules

Tips - Excel with VBA

1001: Exchanging data between Excel and VBA arrays

1011: Array COUNTIF - perform a large number of COUNTIFs on an unsorted array

1021: Performing multiple tasks in an event procedure

Index a cell in a multi-area range

Animate a greeting in the form of a stadium wave (also called an audience wave)

Conditional formatting icon set to show direction of change

Tips - Excel with VBA (Intermediate)

Generate an audio alert

Tips - Excel with VBA (Advanced)

VB(A) access to web pages and web services

Integrating Google Charts into Excel

Using LINQ to open in Excel the newest file in a folder

Tips - VBA

Process all files in a folder and, optionally, in all nested sub-folders

Event Procedures - When are they triggered and in what sequence?

Schedule a Subroutine on a Periodic Basis Each day 

For custom technology solutions, operations consulting, or training contact web-underscore-contact@tushar-hyphen-mehta-dot-cee-oh-em.

By accessing any page or link on this web site other than this page, you agree to the terms and conditions.

Copyright © 2000-2009 Tushar Mehta.
Send comments and suggestions about the web site to web-underscore-contact@tushar-hyphen-mehta-dot-cee-oh-em
Last edited March 13, 2010