Home > Excel > VBA
Top-Rated Links 
Most-Visited Links 

VBA

1200 Excel Macro Examples Update Link / Bad Link? 
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
Updated May 25, 2005 by anant
Rating: (13 Ratings)   Rate this link Total Visits: 8757
 
Excel VBA Tutorial Update Link / Bad Link? 
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 by Anthony
Updated Jan 30, 2007 by Van Hiep
Rating: (2 Ratings)   Rate this link Total Visits: 4529
 
VB Numerical Methods Update Link / Bad Link? 
Free download Excel VBA finance and math code and examples. Huge database of all types of math and finance code suitable for practioners and academics.
Submitted Nov 23, 2004 by Greg Vainberg
Updated Nov 24, 2004
Rating: (10 Ratings)   Rate this link Total Visits: 3464
 
Advanced VBA Tutorial Update Link / Bad Link? 
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
Rating: N/A   Rate this link Total Visits: 3135
 
Excel VBA Examples Update Link / Bad Link? 
The Visual Collection consists of all of our downloadable books on macros. We sell as a collection to provide you 20% savings off of the individual prices.
Submitted Feb 10, 2003
Rating: N/A   Rate this link Total Visits: 2326
 
VBA example code Update Link / Bad Link? 
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
Rating: N/A   Rate this link Total Visits: 2067
 
Advanced Excel VBA Modeling Update Link / Bad Link? 
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 by Anthony
Rating: (1 Ratings)   Rate this link Total Visits: 1695
 
Code Examples for Excel Update Link / Bad Link? 
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 by Dave
Updated Mar 01, 2005
Rating: N/A   Rate this link Total Visits: 1658
 
Macros And Functions Update Link / Bad Link? 
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
Rating: N/A   Rate this link Total Visits: 1552
 
Julian's Excel Macro (VBA) Tips for Beginners Update Link / Bad Link? 
Excel Macros (VBA) tips for beginners. Simplified macros are used here for easy understanding. Includes code samples.
Submitted Feb 15, 2005
Rating: (3 Ratings)   Rate this link Total Visits: 1230
 
Optimize VBA Update Link / Bad Link? 
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
Rating: N/A   Rate this link Total Visits: 862
 
Code Modules And Code Names Update Link / Bad Link? 
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
Rating: (1 Ratings)   Rate this link Total Visits: 805
 
Template Master Toolkit Update Link / Bad Link? 
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
Rating: N/A   Rate this link Total Visits: 709
 
Radio Button Without Form Update Link / Bad Link? 
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
Rating: N/A   Rate this link Total Visits: 690
 
Custom Excel VBA Consulting Update Link / Bad Link? 
EXCELent Consulting Services provides custom advanced-level Microsoft Excel VBA (Excel Macros) application and automation solutions to individuals and corporations. Microsoft Access and Word VBA solutions also available.
Submitted Feb 10, 2003
Rating: (1 Ratings)   Rate this link Total Visits: 593
 
P E R M U T A T E Update Link / Bad Link? 
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
Rating: N/A   Rate this link Total Visits: 447
 
Create Custom Excel Menu Items Update Link / Bad Link? 
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 by Dave
Updated Jul 05, 2005
Rating: N/A   Rate this link Total Visits: 339
 
CodeWarrior Update Link / Bad Link? 
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
Rating: N/A   Rate this link Total Visits: 281
 
Validating UserForm TextBox to Only Accept Numbers Update Link / Bad Link? 
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 by Dave
Updated Jul 05, 2005
Rating: N/A   Rate this link Total Visits: 260
 
VBxtras' List of Products Update Link / Bad Link? 
A very large catalog of VBA products ant tools. Possible to search by product, vendor or by category.
Submitted Sep 02, 1999
Rating: N/A   Rate this link Total Visits: 248
 
Ankur Mohan's Excel VBA Page Update Link / Bad Link? 
Learn VBA the simple way. New view to Excel VBA
Submitted Dec 17, 2006 by Ankur
Updated Dec 18, 2006
Rating: (1 Ratings)   Rate this link Total Visits: 246
 
Return Excel Worksheet Name to a Cell Update Link / Bad Link? 
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 by Dave
Updated Jul 05, 2005
Rating: N/A   Rate this link Total Visits: 214
 
Excel VBA Intersect Method Update Link / Bad Link? 
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 by Dave
Updated Jul 05, 2005
Rating: N/A   Rate this link Total Visits: 204
 
Count of Items in List VBA Update Link / Bad Link? 
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 by Dave
Updated Jul 05, 2005
Rating: N/A   Rate this link Total Visits: 200
 
Code: VBA, PHP, X/HTML, CSS Update Link / Bad Link? 
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 by james igoe
Updated Mar 14, 2008 by james igoe
Rating: N/A   Rate this link Total Visits: 195
 
VBA Seminar (in German) Update Link / Bad Link? 
A first course on how to use Visual Basic for Applications to simplify the use of Excel.
Submitted Sep 12, 1999
Rating: N/A   Rate this link Total Visits: 171
 
CLOSE01.ZIP Update Link / Bad Link? 
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
Rating: N/A   Rate this link Total Visits: 157
 
Baarns Consulting Developers Only Update Link / Bad Link? 
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
Rating: N/A   Rate this link Total Visits: 126
 
Developer JumpStart for Excel 97 Update Link / Bad Link? 
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
Rating: N/A   Rate this link Total Visits: 126
 
  Link To Us

Terms of Use:  
NOTICE: Links you submit to Mathtools.net Link Exchange will be accessible from any part of the world via the web. Any information such links contain may be used by The MathWorks and the public, both within and outside the country from which you posted. Read complete disclaimer prior to use.


  Privacy - Trademarks - Feedback - Terms of Use Copyright 2001-2008 The MathWorks Inc.