 |
| FREE Excel STUFF |
Search |
| Excel Help. Popular |
| NEW! Multiple Excel Search & Links |
| Excel Formulas |
| Excel Macros |
| Excel Newsletter |
| PRODUCTS |
| Up to $139.00 FREE! |
|
Categories & Search |
| Excel Templates |
| Excel Add-ins |
| Excel Training |
| More.... |
| OTHER |
| Excel Development |
|
|
NEW! More Books.. |
|
Complete Excel Excel Training Course, Including Excel VBA Macros. Instant Buy/Download, 30 Day Money Back Guarantee & Free Excel Help for LIFE! TIP! Join the free Excel help forum and get the complete Excel course at HALF PRICE!
NEW! Multiple Excel Sites Search powered by Google. Also, join our free Excel Newsletter
Free Excel VBA Help Forum
(The place to get your questions answered)
Need an Excel macro? Get your Excel VBA questions answered for free, often within
minutes! The forum is the most popular area of our site. Give yourself and/or your
company totally free 24/7 support. You can even upload/download example files!
FREE Excel Downloads All Excel downloads below here are free.
Excel
Forum FAQ List of the most popular asked questions in the
Excel help forum . Excel Formulas
through to Excel VBA macro code.
Excel VBA Frequently Asked
Questions and Answers An ever growing list of popular questions and answers
on both Excel, Excel macros and Excel VBA
Excel VBA Newsletter Archive
Have a browse through our free Excel newsletter archives. Here you will find
a bit of everything from basic shortcuts through to Excel VBA macros. If you like
what you see then sign up, it's completely free!
Excel Charts Here are many examples that can be used to create Excel charts with a difference. The Excel charting pages listed here show many different charting techniques, examples and solutions.
Excel Date and Times
This page is a must if you are wanting to work with dates and times in an Excel
spreadsheet. It explains how Excel stores dates and times, give the magic numbers
needed for dates and times and date and time conversions and functions.
Stop Screen Flicker
in Excel If you record Excel macros, as apposed to writing them, you will
often wish to stop the screen flicker caused by your Excel macro selecting cells
and Worksheets.
Excel Variables A Variable
is used to store temporary information that is used for execution within the Procedure,
Module or Workbook. Before we go into some detail of Variables, there are
a few important rules that you must know about.
Lifetime & Scope
of Excel Variables In Excel, when coding in VBA, we can use what are know
as variables to store information. These variables (as the name suggests) can be
varied and changed to store different data information. As soon as a variable loses
scope it loses its stored value.
Automatically Run Excel Macros Upon Opening Excel Excel has the ability to automatically run/execute any Excel macro code of our choosing when opening an Excel Workbook.
Automatically Run Excel Macros Upon Data Entry Excel has the ability to automatically run/execute any Excel macro code of our choosing when data in any cell on a Worksheet changes. We can do this via the Worksheet_Change event. We can even specify which cell/cells must be changed before running our code.
Move ListBox Item Up/Down Add 2 CommandButtons to your UserForm that will move your multi-column LIstBox items up and down.
Fill Range With Array Elements Use Array Elements to fill range, chosen by user, complete with headings.
Mask Time Entries in Excel Unlike Access, Excel does not allow for us to mask time and/or date entries. However, we can use the Worksheet_Change Event to achieve masked time entries
Select Case Statement One of the best methods for multiple conditions is the Select Case Statement. It does away with the need for multiple If Statements which can make Excel Macros very hard to read and decipher.
Conversion Type Functions These Excel VBA conversion functions can be use to convert from one data type to another.
Calculate Sliding Scale Tax Custom Excel Function (Excel Macros) that can be used to calculate tax based on a sliding scale, or bracket tax.
Excel VBA Loops are used in Excel VBA Macro code to tell Excel to repeat a block of code until a condition is TRUE, FALSE, a specified number of times, or to loop through a Collection or Array.
Send Email From Excel Excel VBA allows us to send emails from within Excel and even send the Workbook as an attachment.
Determine Number of Printed Pages In Excel we can use Excel VBA code to determine the number of pages that will be printed from the active sheet.
Loop Through UserForm Controls Excel VBA UserForms and their associated controls are a great way to present/collect data from users. There are often occasions however when we need to loop through all controls on a UserForm, or only certain specified controls.
Working With Shapes Shapes are those from the Drawing toolbar or the Forms toolbar. The code shows how to loop through them and access their Properties.
Sort Excel Sheets/Worksheets The Excel VBA macro code here can be used in any Excel Workbook, or Excel add-in for sorting Excel Sheets.
Group Excel Sheets/Worksheets by Color In Excel 2000, Microsoft introduced the ability to color the Sheet name tabs. The Excel VBA macro code here can be used in any Excel Workbook that is at least Excel 2000, or higher.
Add Sheets Adding worksheets to Excel is very simple
Sort Arrays The Excel VBA macro code here can be used in any Excel Workbook. When run, it will sort the 1 dimensional array of strings, MyArray
Protect/Lock Excel VBA Code When we write VBA code it is often desired to have the VBA Macro code not visible to end-users. This is to protect your intellectual property and/or stop users messing about with your code.
Password Protect Worksheet Viewing With the aid of some Excel VBA code placed the private module of the Workbook Object (ThisWorkbook) we can password protect a Worksheet from viewing to all those that do not know the password.
Excel Calendar for Valid Dates Easy to follow steps on how to create a user friendly Excel Calendar using Excel VBA.
Create a Worksheet Calendar The Excel macro code here will create a calendar on a new Worksheet. The current day will always be highlighted dynamically each day.
Deleting Rows in Excel Some examples on deleting rows in Excel that meet a criteria. Most of these methods are far more efficient and quicker that the conventional ways of using a loop in Excel VBA.
Delete Rows in Excel Based on Condition/Criteria One very common question is: "how can I delete rows from my Excel Worksheet based on a specified criteria, or condition?"
Delete Module via VBA Code The code here can be used to delete the module which houses the code. In other words, it deletes itself after running once
Delete Workbook Event Code The code here can be used to delete all Event code within ThisWorkbook
Delete Sheet Event Code With Code The macro here can be used to delete Sheet Code based on the Sheet CodeNames supplied to the Select Case Statement within the Sheets Collection Loop . It's ideal to use when you need to copy Sheets from a Workbook but do not want the code to copy with the Sheets.
Decreasing Validation Lists If you need to have a list of options that decrease as users select from it, you can Data Validation and some Excel VBA Code
Limit Scroll Area on an Excel Worksheet With the aid of Excel VBA and the Worksheet Activate Event we can restrict the scrollable area on any Excel Worksheet.
Creating a Worksheet Index When working with Excel, many users end up with a lot of different Worksheets which then makes navigation cumbersome. This page shows you how to create a Index Sheet via Excel VBA.
Automatically Add Date Into Cell It is often asked how one can have a date, or date and time, entered into a corresponding cell after data in entered into other cells. Let's suppose you need the current date entered into Column "B", on the same row as Column "A" data is entered. The date entered must be static so that means we cannot simply use the TODAY(), or NOW() functions.
Excel Find Method The Excel Find Method is an excellent tool to use when writing Excel VBA, or Excel macros.
Find Dates/Find Method The Find Method is an excellent method to use in Excel VBA macro code. It is many hundreds of times faster than a VBA loop , which is often erroroneously used to locate data. However, things become somewhat tricky when using the Find Method to Find Dates. Even recorded Excel Macros can fall over.
Extract nth Word From Text in Excel With the aid of Excel VBA we can write a custom formula/function, or user defined function to extract out the nth word from a text string.
Onto Excel VBA Macros Page 2
Excel Dashboard Reports & Excel Dashboard Charts 50% Off
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
