Ozgrid, Experts in Microsoft Excel Spreadsheets

Excel VBA - Excel Macros

TRY OUT: Smart-VBA | Code-VBA | Analyzer-XL | Downloader-XL | Trader-XL| More Free Downloads.. Best Value: Finance Templates Bundle

 Excel VBA & Macro Code Tips, Tricks

Excel VBA INDEX Page 1 Of 2

Free Excel Content & Downloads From Ozgrid: Free Excel Training With Free Question Support | Excel Downloads (templates, add-ins etc) | Excel Downloads 2 (example files) | Nifty Excel Formulas Examples  | NEW! Excel Custom Functions Add-in |  Excel List to Table Creator Create an classic Excel table from data in a single column list. | Fill Blanks Excel Add-in Fill blanks in a list with the cell above | Data Validation Some basic and advanced uses of Data Validation from Ozgrid  | Hey! That is Cool! Hundreds of free Excel tips, tricks and Excel add-ins from Excel Help forum members | Excel Resources Or, try our special Excel Search powered by Google. | UDF's Custom Excel Functions |  Excel Help Forum

Excel Formulas, Tip, Tricks and Feature Examples

Live Excel VBA Feeds You Can Subscribe to: AdvancedFilter in VBA | Autofilters In VBA | Conditional Formatting In VBA | Custom Functions | Excel On The Web | VBA Events |VBA Object Model. More Excel VBA Feeds

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

Working With Worksheets In Excel VBA Macro Code The Macros here show us multiple ways to have our VBA Macro Code apply to specific Worksheets. Copy code into any standard Module in the Excel VBE.

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.

InputBox Function Collect data or ranges from you users

Excel Message Box (MsgBox) Function

Change Excel Text Case to Upper, Lower or Proper

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.

Add or Subtract Dates Here's how to create relatively easy Date Adder by using a UserForm, 3 TextBox Controls, 5 Label Controls, 1 ComboBox Control and 1 CommandButton Control.

Transpose Rows Into Columns Macro code here transpose every x rows into columns.

Copy Multiple Column & Row Records Into Single Row Records

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.

Debug VBA Code

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.

Transfer Multi-Select ListBox To Range Of Cells

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

Mask Date Entries in Excel

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.

Restricting Excel VBA Loops I would like to show you 2 ways to restrict looping by using the COUNTIF Function with the Find Method. The 1st code uses a whole cell match, while the 2nd uses a part cell match.

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

Add Sheets in Numeric Order

Add Sheets in Weekday Order

Add Sheets in Month Order

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 2007 Macros From MicrosoftExcel Macros From Microsoft
Change macro security settings in Excel About macros in Excel
Create or delete a macro Copy a macro module to another workbook
Copy a macro module to another workbook Create a macro
Edit a macroDelete a macro
Run a macro Edit a macro
Workbook contains a user form or class module Enable macros to run
Enable or disable macros in Office documents Excel 4.0 macro functions
What is a macro and why you should care Run a macro
 Stop a macro
 Troubleshoot macros
 Introduction to custom macros in Excel
 What is a macro and why you should care

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 [email protected] 31 days after purchase date.



Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

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

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS

Watch the latest videos on YouTube.com