VBA

Infinite opportunities? Endless problems? Limited resources? Talk to us!

	Operations Consulting	Software Consulting	Publishing and Training		Applied Solutions	Excel add-ins and tutorials	Charts	Excel and VBA Case Studies	VBA tutorials	PowerPoint Add-Ins	Miscellenia

You are on the Home/Excel/VBA page

About this site

Visual Basic for Application (VBA) code for Excel and Developer-Ready Components

Getting Excel to write the code

Beyond the macro recorder

Understanding the Excel object model

Writing a User Defined Function (or UDF)

Creating an add-in

The power of Variants

Why won't Excel quit?

Digitally signing code

Understanding code

Accessing embedded or linked objects

Using VBA to work with multiple sheets simultaneously

Associate Excel objects and OnTime and OnKey methods with subroutines with arguments

Monitoring Events

Defensive programming

Developer Aids

Decode mnemonics (constant values)

Using the Run method of the application object to pass arguments by reference

Examples

Object Oriented Programming -- Find the center of a circle

Simple encoding

Ready to use components

A calendar component

Generate timed events

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.

Ads from amazon.com

[Optional] Survey (current rating of site: 3.7 out of 4) If you will take a moment to provide your comments, it will help improve the site both for you, and for other visitors.

On a scale of 4 (just what I need)
to zero (totally useless)

How do you rate the information

on this page?

on this site?

[Optional]

Your name
Your email address
Other comments

Monitor page
for changes

by ChangeDetection

A comment selected at random:

Copyright © 2000-2008 Tushar Mehta.
Send comments and suggestions about the web site to webmaster@tushar-hyphen-mehta-dot-cee-oh-em
Last edited April 14, 2008