|
Convert Text and Cells with Formulas to UpperCase with VBA
|
|
VBA codes to determine Last Used Row & Last Used Column in Excel
|
|
Change Font Color in Cells with VBA
|
|
Find Smallest and Largest Value in a Range with VBA
|
|
Application.OnTime VBA, Schedule Excel to Run Macros at Periodic Intervals or a Specified Time
|
|
Declaring Variables, Using Dim Statement, Variable Names & Variable Data Types in VBA
|
|
Find Method in Excel VBA, Find Multiple Occurrences, Find Method to do Vlookup, Find Method to Search Date
|
|
Excel VBA Events, Event Procedures (Handlers), Triggering a VBA Macro
|
|
Worksheet Change Event, Excel VBA
|
|
Worksheet Selection Change Event, Excel VBA
|
|
Excel VBA - Convert Excel Column Number to Column Letter, and Column Letter to Column Number
|
|
Run VBA Macros on Protected Worksheet; Unprotect & Protect, UserInterfaceOnly argument; Worksheet.Protect Method
|
|
Excel VBA Dates & Time, Format Function, User Defined Date, Number & String Formats
|
|
Excel VBA Date & Time Functions; Year, Month, Week & Day Functions
|
|
Custom Number Formats, Date & Time Formats in Excel & VBA; NumberFormat property
|
|
Excel VBA Loops, with examples. For Loop; Do While Loop; Do Until Loop.
|
|
Conditional Statements in Excel VBA - If...Then...Else Statements (VBA)
|
|
Conditional Statements in Excel VBA - Select...Case Statement (VBA)
|
|
Excel VBA: ActiveX Controls, Form Controls & AutoShapes on a Worksheet
|
|
UserForms in Excel VBA - UserForm Basics; Add Controls dynamically at run-time using the Add Method; UserForm Controls (A Snapshot)
|
|
Excel UserForm and Controls - Properties; Setting control properties at design-time or run-time.
|
|
Excel UserForm Controls - Label, TextBox and CommandButton
|
|
Excel UserForm Controls - ComboBox and ListBox: AddItem Method, BoundColumn, List Property, ListIndex, RowSource, Selected Property, ...
|
|
Excel UserForm Controls - CheckBox, OptionButton and ToggleButton
|
|
Excel UserForm Controls - Frame, MultiPage and TabStrip; group OptionButtons; create a wizard using MultiPage control
|
|
Excel UserForm Controls - ScrollBar and SpinButton; create Mortgage Calculator using ScrollBar
|
|
Excel UserForm Controls - Image and RefEdit; use LoadPicture property with GetOpenFilename Method
|
|
Excel VBA Arrays: One-Dimensional & Multi-Dimensional, Dynamic Arrays, ReDim Statement, Lower & Upper Bound, 200-Year Calendar in Excel, ParamArray
|
|
200-Year Calendar in Excel VBA, Free Download
|
|
Create an Excel Pivot Table report using VBA
|
|
Referencing an Excel Pivot Table Range using VBA
|
|
Reference Pivot Fields and Pivot Items in an Excel Pivot Table, using VBA
|
|
Excel Pivot Table Address, Location, Move & Copy using VBA
|
|
Excel Pivot Table Layout and Design, using VBA
|
|
Excel Pivot Table Properties & Settings, using VBA
|
|
Refresh Excel Pivot Table and Cache of PivotTable, using VBA
|
|
Excel Pivot Tables Grouping: Group Items, Group Data and Group Date Values, using VBA
|
|
Excel Pivot Tables: Sort Fields, Values & Dates, use Custom Lists, with VBA
|
|
Excel Pivot Tables: Filter Data, Items, Values & Dates using VBA
|
|
Excel Pivot Tables: Summary Functions, Custom Calculations & Value Field Settings, using VBA
|
|
Excel Pivot Tables: Insert Calculated Fields & Calculated Items, Create Formulas using VBA
|
|
Create & Customize Excel Pivot Table Charts, using VBA
|
|
Excel VBA - Record and Run Macros using the Excel Macro Recorder
|
|
Visual Basic Editor in Excel (VBE) - the VBA Code Editor
|
|
Excel VBA Objects; Excel Object Model; Access a Workbook, Worksheet or Range Object; Set Object Properties & Call its Methods
|
|
Starting with VBA in Excel, Writing VBA Code for Macros or Procedures
|
|
Excel VBA - Message and Input Boxes in Excel, MsgBox Function, InputBox Function, InputBox Method
|
|
Excel VBA Application Object - the Default Object in Excel
|
|
Excel VBA Workbooks - Reference, Open, Add, Name, Save, Activate, Copy & Close Workbooks; SendMail Method
|
|
Excel VBA Worksheets - Refer, Activate or Select, Add & Name, Copy or Move, Hide or Display, Delete, Page Layout & View, Calculate
|
|
Excel VBA Referencing Ranges - Range, Cells, Item, Rows & Columns Properties; Offset; ActiveCell; Selection; Insert
|
|
Excel VBA Refer to Ranges - Union & Intersect; Resize; Areas, CurrentRegion, UsedRange & End Properties; SpecialCells
|
|
Excel VBA: Calling Sub Procedures & Functions, Placement in Modules
|
|
Excel VBA: Passing Arguments to Procedures, Parameter Arrays (ParamArray)
|
|
Excel VBA Custom Classes & Objects, Class Modules, Custom Events
|
|
Excel VBA - Empty, ZLS, Null, Nothing, Missing
|
|
Excel VBA String Functions: LEFT, RIGHT, MID, LEN, REPLACE, INSTR, INSTRREV
|
|
Excel VBA String Functions: SPLIT, JOIN, CONCATENATE
|
|
Excel VBA Errors & Error Handling, On Error & Resume Satements, Exit Statement, Err Object
|
|
Excel VBA Debugging Tools in Visual Basic Editor - Breakpoints & Break Mode, Stepping Through Code, Debugging Views
|
|
Charts in Excel VBA - Add a Chart, the Chart object & the ChartObject object
|
|
Chart Elements in Excel VBA (Part 1) - Chart Title, Chart Area, Plot Area, Chart Axes
|
|
Chart Elements in Excel VBA (Part 2) - Chart Series, Data Labels, Chart Legend
|
|
Child Objects common for many chart elements: Border Object, ChartFillFormat Object, Interior Object, Font Object
|
|
ChartFormat object - line, fill & effect formatting for chart elements: FillFormat object, LineFormat object, ShadowFormat object, GlowFormat object, SoftEdgeFormat object, ThreeDFormat object
|
|
Create Charts in Excel VBA: Embedded Charts - Line with Markers; Clustered Stacked Column Chart; Clustered Stacked Bar Chart displaying Variance; Pie chart; XY Scatter chart & Bubble chart
|
|
Automate Microsoft Word from Excel, using VBA
|
|
Automate Microsoft Outlook from Excel, using VBA
|
|
Export contacts from Outlook to Excel - automate in vba
|
|
Import Contacts from Excel to Outlook - automate in vba
|
|
Automate Outlook using vba: Sending Email from Excel using Outlook
|
|
Automate Microsoft PowerPoint from Excel, using vba, Run a Slide Show
|
|
Microsoft Access: ActiveX Data Objects Library (ADO)
|
|
Microsoft Access: Use ADO to Execute SQL statements
|
|
Import or Export Data from Access to Excel using ADO
|
|
Microsoft Access: ActiveX Data Objects Extensions (ADOX)
|
|
Connecting to Microsoft Access Database from Excel VBA, using DAO Object Model
|
|
Microsoft Access DAO Object Model: Create an Index, Create Relationship between Fields, Create and Exceute a Query
|
|
Microsoft Access DAO Object Model: Import or Export Data from Access to Excel
|
