| 1200 Excel Macro Examples |
|
Add over 1200 Excel VBA examples directly into the Microsoft Excel Visual Basic Editor. When you select Help, the Visual Basic Macro Examples help file appears. This is a must for Microsoft Excel macros and code.
Submitted: Nov 11, 2002
|
| Excel VBA Tutorial |
|
Free open source Excel VBA examples on various finance, statistics, mathematic, and general topic. It includes random numbers generator, standard deviation, regression, simulation, option pricing, tutorial, forum and more.
Submitted: Nov 23, 2004
|
| Advanced VBA Tutorial |
|
John Lacher's advanced VBA tutorial. Subjects dealt with: Exporting Excel Data in Special Formats, Importing Text Files into Open Workbook, Comparison of Three Sort Methods.
Submitted: Sep 02, 1999
|
| VBA example code |
|
Get all the VBA example code found in "Excel 97 Annoyances" by downloading XLANNOY.ZIP. This is a 50K file that contains the Intro to VBA.xls workbook. This workbook contains all the VBA macros and utilities from the book, ready-to-run!
Submitted: Sep 14, 1999
|
| Advanced Excel VBA Modeling |
|
Advanced Excel VBA prorgrams in finance and statistics with open source codes for Sale. Include option pricing models with greeks, random numbers generator, Monte Carlo simulation and many more.
Submitted: Jan 12, 2005
|
| Code Examples for Excel |
|
These pages of our web-site are specific to Visual Basic for Applications for Excel. It contains many tips and tricks, useful code, user-defined functions and much more.
Submitted: Feb 25, 2005
|
| Macros And Functions |
|
As a VBA programmer, you'll need to know the difference between SUB procedures and FUNCTION procedures. This page describes the difference, and the limitations of each type.
Submitted: Sep 07, 1999
|
| Julian's Excel Macro (VBA) Tips for Beginners |
|
Excel Macros (VBA) tips for beginners. Simplified macros are used here for easy understanding. Includes code samples.
Submitted: Feb 15, 2005
|
| Optimize VBA |
|
As your VBA projects get larger and more complex, it becomes more important that your code is written to be as efficient as possible. Learn about several techniques you can use to improve the speed (and reliability) of your VBA code.
Submitted: Sep 07, 1999
|
| Code Modules And Code Names |
|
A common mistake among new VBA programmers is that they put their code in the wrong module. When this happens, Excel can't find the code, and it can't be executed. This page describes the different types of modules in Excel VBA, and what you should and shouldn't put in each type.
Submitted: Sep 07, 1999
|
| Template Master Toolkit |
|
A step-by-step guide and collection of VBA tools to create your own templates. Just about any user can create their own templates and use the Template Toolbar that comes with each of the Excel Results templates.
Submitted: Sep 11, 1999
|
| Radio Button Without Form |
|
Graphical User Interface (GUI) is one of the most powerfull tool for developing user-friendly software. With the advent of VB (and VBA) it has become all the more easy for even beginners to incorporate simple GUI in their programs. However, as with any other tool, this tool also should be used with discretion. Forms, buttos and similar controls should be used only if they make the task of the usaers easier. Never use them for their own sake. The relatively simple example in the accompanying article shows how, with a little thought, a situation where a form with radio buttons would have unnecessarily hampered the user, salvaged using a small code in VBA. It also introduces you to different events available in Excel VBA.
Submitted: Feb 04, 2001
|
| P E R M U T A T E |
|
PERMUTE.XLS is an Excel 5 workbook (16 Kb in a ZIP archive) which generates permutations of letters you input. There is some first class VBA here, with Jan demonstrating a very inventive solution to the problem of dynamically reiterating through an array and more.
Submitted: Sep 07, 1999
|
| Create Custom Excel Menu Items |
|
It is possible to customize Excel in many different ways. However, to make your Excel spreadsheets have that professional look and feel, one can add their own custom menus to an existing Excel toolbar.
Submitted: Jul 04, 2005
|
| CodeWarrior |
|
Among this set of downloadable programming tools, you'll find the section: Excel add-ins in CodeWarrior: "A framework for writing Excel add-ins (XLLs) for 68K and PowerPC Macs and 32-bit Windows in CodeWarrior. 68K, 68K-with-FPU and PowerPC builds can be easily generated from the same source code and integrated in the same fat binary: Excel will transparently call the right one. The PowerPC add-ins are fully native and Excel 5 calls them without any mode switching... Requires the Excel 5 Developer's Kit (from Microsoft) and CodeWarrior 10 or later."
Submitted: Sep 02, 1999
|
| Validating UserForm TextBox to Only Accept Numbers |
|
If you are fairly comfortable with Excel VBA you will most likely want to design a UserForm to ensure correct use of your Spreadsheet. However, just placing some TextBoxes on a UserForm for users to enter data is not enough. For example, the TextBoxes may be intended to take only numeric data and not Text strings
Submitted: Jul 04, 2005
|
| Ankur Mohan's Excel VBA Page |
|
Learn VBA the simple way. New view to Excel VBA
Submitted: Dec 17, 2006
|
| Return Excel Worksheet Name to a Cell |
|
In Excel it is possible to use the CELL function/formula and the MID, LEN and FIND to return the name of an Excel Worksheet in a Workbook. We can also use a handy Custom Excel VBA Function
Submitted: Jul 04, 2005
|
| Excel VBA Intersect Method |
|
The Intersect Method will return a Range Object that represents the intersection of two, or more, ranges. It can be used to determine if a specified Range Object intersects another specified range(s). Or, in layman's terms, does a specified range intersect another range(s).
Submitted: Jul 04, 2005
|
| Count of Items in List VBA |
|
With the aid of a Pivot Table and Excel VBA we can get a count of each item that appears in a list
Submitted: Jul 04, 2005
|
| Code: VBA, PHP, X/HTML, CSS |
|
Designed to share VBA code and resources, includes work in the following:
- Drill down into Pivot Charts via Shift+Click
- Transpose Array (GetRows)
- SQL Execution and Logging
- E-Mail String Verification
- URL String Verification
- Export Access Tables to Excel
- Worksheet-focused Illegal Character Replacement
- XLA Example: Operation Management Functions
- XLA Example: Euro-Dollar Conversion
Submitted: Apr 30, 2006
|
| VBA Seminar (in German) |
|
A first course on how to use Visual Basic for Applications to simplify the use of Excel.
Submitted: Sep 12, 1999
|
| CLOSE01.ZIP |
|
CLOSE01.XLS contains a single Sub which demonstrates and explains a method for shutting down these user Workooks when your system starts.The best place to do this is probably from your Auto_open.
Submitted: Sep 07, 1999
|
| Baarns Consulting Developers Only |
|
Baarns is committed to helping you be productive while working in Microsoft Office applications. Baarns Consulting specializes in automation using Microsoft Office Professional applications and Back Office solutions. These tools were written specifically for Developers by Baarns Consultants. Many are available for Office97.
Submitted: Aug 08, 1999
|
| Developer JumpStart for Excel 97 |
|
The BDJS is a subset of the methodology used by Baarns Consulting to create custom VBA solutions for major corporations. We are in the process of upgrading our methodology to Excel 97 VBA.
Submitted: Sep 11, 1999
|
|
