Learn Excel Macros [VBA] Step by Step

Home Excel 2003 Excel 2007 Macros Excel 2003 Excel 2010
     Webhosting by Godaddy     MS Excel Books


VBA Modules
How to access worksheet cells with a macro in Excel
How to access Excel worksheet cells using the cell property in a macro
Calculations in excel using macros
Formatting Text and Numbers using macro in Excel
Interactive Calculations Macro - ActiveCell, Offset and Inputbox
If-Else Function Macro
Nested-If Function Macro
Automation Using a 'Do While' Loop in Microsoft Excel

VBA UserForms
What is a userform in Excel?
UserForm to automate calculations and validate data entry
Find the next empty row for automatic data entry using Excel UserForm
Adding and using a combobox on a Userform
Add and code the clear and cancel command buttons on userform
Open userform automatically
How to Open the UserForm using a Command Button on a Worksheet

Miscellaneous - Solutions
Another Method to Find the next empty row for data entry
Tranferring data from the userform to an Excel worksheet
Custom functions 
How to place an image in an image control on an Excel user form based on worksheet data Interesting Solution Using A Do while Nested Loop Macro
How to change the row height and column width using a macro
Automated drawing using nested for loops
Payroll program using VBA and Vlookup
How to automate overtime and wages calculations using loops
How to use a list-box on a user-form in Excel
How to populate a list-box on a user-form using arrays
How to populate a list-box on a user-form using a named range
How to use a check-box with a list-box on a user-form in Excel
How to find the Thanks-Giving-Date using a custom function
More Solutions...
Home Excel 2003 Excel 2007 Macros Excel 2003 Excel 2010