Free Microsoft Office Training and Tutorial Resources
    

Blog Roll:
Free Microsoft Office Training & Tutorials
Free Adobe & Macromedia Training & Tutorials
Free Web Development Training & Tutorials
Intelligentedu.com Blogs
- Free Technical Computer Training
 - Free Computer Books & Ebooks
Top Links:
Free Training By Email
Free Computer Training from EdComp
Free Computer and I.T. Training


February 21, 2007

160 Excel VBA Tutorials

This is a comprehensive linked list of 160 Excel Tutorials and How Tos teaching how to use Macros and code using VBA in Excel. VBA is an abbreviation for Visual Basic for Applications, its the Microsoft Office scripting language used to customize the applications. These learning materials include instructions for performing the demonstrated tasks and are hosted by three excellent Excel tutorial sites: MrExcel, Chip Pearson, and John Walkenbach, all together containing over 500 Excel Articles and Tutorials.

Excel VBA Tutorials with Instructions

Excel Macros
Excel VBA Macros
Add a Module with VBA
Add Row while copying and manipulating data
Add the Path to your Worksheet Footer when Printing
Add today’s entries to the next empty row on a master sheet
Adding and Deleting with VBA
Animation in Excel
Application Events
Application-Level Names (Hidden Name Space)
Arrays - CSEs – in Excel Visual Basic
Audio - Playing Sounds in Excel
Automate a tedious process with VBA Macros
Bypass Delete Confirmation
Change Name Box List width
Change macro to import text file in next available row instead of using A1
Change the worksheet tab name to reflect the value in cell A1
Changing a cell’s background color
Changing Tab Color
Color - Counting based on Interior or Font Color
Color - Counting by and Summing By Color
Color - Highlight Duplicate Entries
Color - Highlighting an Active Cell
Color - RGB Values
Convert Text to Lower Case
Converting Measurements To and From
Copy a Macro to Another Workbook Automatically
Copy Sheet, Preserving all Formatting
Copy the Previous row into the Next Blank Row
Counting cells by interior color using VBA
Create 78 Unique Sheet Names with Identical Data
Create a TOC (Table of Contents) for your workbook
Create a unique record number
Create a Word Document from a Row of Data
Create and name a new worksheet with VBA
Creating multiple lines of text in a messagebox
Creating Page Breaks in Excel-automaticaly
Custom Document Properties
Custom Functions
Custom Menus in the Visual Basic Editor(VBE)
Daily Import Automation with Unique Sheet IDs
Data Validation – Use a Defined Name to validate with data on another worksheet
Dates - Day of the Week with VBA
Dates - Find with VBA
Declaring a Variable in VBA
Declaring an Object
Default Properties of a Class
Delete a worksheet in a macro without having to see the “This worksheet will be permanently deleted”
Deleting VBA
Display Screensaver in Excel
Displaying AutoFilter criteria
Document Properties
Downloading Files using Excel
Duplicate Entries – Replace
Eliminate “/” from File Names when Saving with a Macro
Email a Worksheet From Within Excel
Emulate Lotus’ Print Suppression
Excel Crash on Mouse-over of object
Exit a worksheet with or without saving
Export VBA Code to a Text File
Exporting to Text
Fill Next Row with Previous Row’s Data
Find the last row of data in a range
First Monday of the Year
Formatting Time Values
FTP within Excel
Headers and Footers – with VBA
Headers and Footers in Excel
Hidden Name Space – Application-Level Names
Hiding a range depending upon user selections
Highlight Active Cell Location
Highlight Cells with Today’s Date
Highlight the active cell
How do I get rid of a Macro?
Importing - Text Files to Excel
Increment a Counter everytime a Userform is opened
Inputbox to accept specific data
Link back to original workbook
Maximized view on open
Mailing Labels in Excel with VBA Utility
Module-What is it? 		No Blank Rows
No Duplicate Rows
OnTime Method
Open Other Applications from Excel
Opening Chm (or HTML Type Help) files
Optimize Your Code!
Phone Calls within Excel
Phone Numbers – Splitting(Parsing)
Play a MIDI File when Value Exceeds Set Limit
Printing - Cell Comments
Printing - Cell Formulas
Programming a messagebox for user responses
PROPER - Converting Text Case
Proper Text
Protecting specified data using VBA
Quicken and Excel: Streamline Categories on Copied Reports
Range - Bringing a Range Center Screen with VBA
Range - Referring to Cells in Another Range
Range - Reverse a Range with VBA
Range - Reverse Cell Order
Range - Select the Current Named Range
Ranges - VBA for Named Ranges
Record/Playback a WAV file in Excel
Record a Macro using Relative References (TechTV)
Recycle Bin
Removing a set number of characters from a cell
Removing hyperlinks from a worsheet
Removing text-string characters
Reset Application.ScreenUpdating for forward compatibility with Excel XP
RGB Colors
Run a Macro Automatically When the Workbook Opens
Run a Macro Following Cell Value Change
Run a Macro from a Command Button
Run a Macro from a Cell
Save - Save and Return to Selection
Save a Workbook with Cell A1’s Data
Scheduled Procedure – Using OnTime
Select Current Array
Selecting files within VBA
Selection Change to Highlight Current Row and Column
Setting a font name with VBA
Sorting - Worksheets
Stopping an Endless Loop
Testing Anti Virus Applications using Excel
Text - Converting to Upper or Lower Case
Text to Columns using VBA
Time - Working with Time Zones
Time: Military Time with No Colon
Timers
UDF(User Defined Function)-Use a Calculated Range in a Standard Function
Unselect a Cell or Area
Upper Case – Converting To/From
Use Cells(Row, Column) instead of Range() when looping through several columns
Use Cells(Row, Column).Name = “MyRange” to Simplify Naming a Range
Use Set to create an Object Variable instead of a regular variable when referencing cells
Use Workbook_Open to open a Userform when a workbook is opened
Userforms - Modeless
Userforms in Excel ‘97 and beyond
Using Inputboxes
Variable - Declare
VBA How to: Macros on the Web
VBA How To: Record and Customize your own macros
WAV Files in Excel
What is a Code Module?
What is a Module?
Workbook - Close All
Workbook - Returning Properties
Workbook - Save All
Workbook Object – Document Properties
Working with Functions in a Macro
Working with Userform controls
Worksheet - Call a Macro from a Worksheet
Worksheet - Returning Sheet Name
Worksheet Protection after Sorting
Worksheets - Referencing from a Formula
Worksheets - Sorting
Zoom - To a Range
Oracle Data in Excel

Popularity: 31% [?]

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • del.icio.us
  • blogmarks
  • Furl
  • Reddit
  • Shadows
  • StumbleUpon
  • YahooMyWeb



Related Posts:
  • 15 Microsoft Excel Lessons with Exercises
  • 16 Excel Video Tutorials
  • Free Microsoft Excel Video Training
  • Excel 2003 Tutorial from the University of Texas
  • Free Microsoft Excel Ebook

    • Tags for this post>>
    Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 11:23 am

    No Comments »

    No comments yet.

    RSS feed for comments on this post.

    Leave a comment

    You must be logged in to post a comment.