- What Is VBA
- What Is Meant By Macro
- Classification Of Macros
- What Is Procedure
- How To Enable Developer Tab In Excel 2007 2010 2016
- How To Change The Comment Color In Excel VBa Macro
- Object Hierarchy
- Ways To Provide Comments In VBA
- Default File Location To Save Excel
- Option Explicit In VBA Macros
- Locals Window
- Watch Window
- Immediate Window
- What is the purpose of Dot seperator - or - Intellisence
- What is DIM - How to Decleare a variable
- What is Meant by DIM --- Dimension
- Data Types In VBA Macros
- Scope of Variables
- Data Variables Vs Object Varaibles
- Variant Data Type
- Recording Macros Examples
- IF Condition
- Select Case Grades
- Logical Operator
- Sheets in New Workbook Property
- Display Alerts Property
- Wait Method
- Application Object Properties and Methods
- Calculation Property of Application Object
- Select workbook using FileDialogFilePicker
- Range Object Introduction
- FillUp - FillDown - FillRight - FillLeft
- Group And Ungroup The Rows Using Group Method Of Range Object
- Insert and Format the button Shape in Excel
- Provide Target Status with Oval Shape
- Create Student Identity Card - Part I
- Create a Workbook Addin for Identity Card- Part II
- Insert a shape in worksheet
- Add And_ Change The Formatting Of Shape In Excel Using VBA Macros
- Advance Filter
- AutoFilter
- Autofilter Sort
- Aufilter Examples using Wildcard Characters
- Filter the Data using SERACH BOX
- Sort Multiple Columns and Custom Sort
- Sort Defined Range or Portion Of Column Using VBA Macros
- Extract The Data from One Workbook to Another Using Index and Match Functions
- Extract the data from one workbook to another using VLookup
- Find VLookup value using COUNTIF function
- VLookup Function - When TableArray Considered from Multiple sources
- Create and Extract the data from Dictionary
- Collection
- Array Introdcution
- Create Array based on sheet Name length
- Create Two Dimension Arry With Numbers Using VBA Macros In Excel
- Create Single Dimention Array And Bifurcate The Data Based On Its Data Type
- Create Single Dimension Array Using VBA Macros
- Difference Between OptionBase Zero And OptionBase One In VBA Macros
- Remove Duplicates from the Array
- Copy the Data from One Range to Another By Creating Two Dimensional Dynamic Array
- Transfer a MODULE from one Workbook to Another
- Fill the cells with the custom data using Autofill
- Autofill Method
- Create Pivot Table
- Display PivotField and PivotItem Names on MessageBox
- Fomat the PivotTable with Styles
- Formatting Of PivotTable Structure
- Conditional Format the PivotTable based on Its value
- Create Pivot Table - Pivot Chart - Slicers - Manually and Programatically
- Import The Data from Access Database to Excel by using OpenDatabase Method of Workbooks Object and create pivot table
- Pivot Fields and Pivot Items in Pivot Table
- Create Multiple Pivot Tables using Single Pivot cache --- Select the Data Using Userform
- ActiveX Controls Introduction
- Check Box
- Combo Box
- Text Box
- Create Scrore Card Using Text Box Of Userform - Provide Validations
- Option Button
- Add a Button and Fit in a Cell
- Command Button
- List Box
- Add Multiple Columns to The Listbox
- Add Multiple columns to the Listbox based on Data selected in combobox
- Create Listbox from form control and Add the values by considering as Shape
- RefEdit
- Create Dependent DropDown
- Insert Values in combobox box and extract the from combobox added on worksheet
- Loop through all the controls of Userform and Provide the control Names on message box
- Export The data from Worksheet to Listbox and Import from Listbox to Worksheet. Initialize Event of Userform and Change event of Combobox
- Add the Columns to Listbox Dynamically
- Command Bar Introduction
- FSO - File System Object
- Managing Files
- File Management MKDir
- File System Object
- Open The Workbook If Exists in the path Using FILE SYSTEM OBJECT(FSO)
- Create a Folder If not Exists in the path using FILE SYSTEM OBJECT(FSO)
- How to collect Excel Files from a Folder Using Dir Function
- How To Collect Files From A Directory Using DIR Function
- How To Collect Files From A Directory Or Folder Using DIR Function
- How To Collect Only Excel Files From A Folder Using Dir Function In VBA Macros
- Loops introduction in VBA Macros
- For ... Next Loop Introduction
- Step Key Word ... and Exit for In VBA Macros
- For each Next Loop Introduction
- Do Loops Introduction
- Loops Introduction
- For Next Loop Introduction
- Do Loops Introduction
- Properties Methods Introduction
- Text Property
- Column Property
- Row Property
- Count Property
- Address Property
- Font Properties In VBA Macros
- Change The font color using Range object and Cell Property -- Combo
- Write Name in Different Font Styles
- WrapText Property
- Font Property
- Name Property
- Range Property
- Interior ColorIndex Property
- Print Interior ColorIndex numbers in a Single Column
- Print Interior ColorIndex numbers in Multiple Columns - 10 Per each Column
- Change The Sheet Tab Color Using ColorIndex Property In VBA Macros
- Hidden Property Of EntireColumn And EntireRow
- Hide And UnHide Worksheets
- Difference between Visible Hidden VeryHidden Properties of Worksheet Object
- DoubleRule
- RowHeight And ColumnWidth Property
- Change The Row Height and Column Width
- CurrentRegion Property
- Resize Property
- HyperLink Property
- AddComment_Method
- Range Property
- Find the Last Used cell
- Identify the Last Used cell in 4 different directions
- UsedRange Method
- Select Method
- Clear Method
- Offset Method
- Merge And Unmerge Methods
- Active Method
- Delete Method
- Select Method
- AutoFit Method
- Cut Method
- Copy Method
- Copy and Paste The Data With In Coding Workbook
- Copy and Paste The Data By Selecting New workbook
- Copy and Paste the Data from source workbook to Destination workbook
- PasteSpecial Method
- Clear Method
- TextColumns Method
- TextTocolumns Method of Range Object with Different Delimiters
- Replace Method
- FollowHyperlink Method
- Fill Blank Cells
- FillAcrossSheets Method
- Union Method
- Union Method Using VBA Macros
- Offset Method
- Lock_The_Cells_Using_Protect_Method
- lock The required Range and Unlock the Reamining Worksheet using Locked Property and Protect Method
- Protect and Unprotect Worksheets Using xlDialogProtectDocument
- Functions_Classification
- Custom Functions
- Retrieve Unique records after eliminating duplicates and create data validation dropdown by creating custom functions
- DateSerial Function
- Find The Month Name with Abbrevation and With Out Abbrevation
- Retrieve Month wise dates using Day and Dateserial Functions
- Sub Total and Grand Total
- Group The Rows
- ABS Function
- Time Date Functions
- Find Month Wise Days in Excel
- Find Number of Days In a Month
- Retrieve MonthNames along with Abbrevations
- MonthName Function
- Find Working Day or Holiday Using WeekDay and WeekName Functions
- DateDiff Function
- DateDiff Function - in Terms Of Days, Hours, Minutes, Seconds
- DatePart Function
- WeekDay Function
- DateAdd Function - in Terms Of Days, Hours, Minutes, Seconds
- Instr Function
- MidFunction
- MID Function - Retrieve the Portion of the text Using MID Function
- Mid Function: Extract Strings - Numbers
- Mid Function: Extract Strings - Numbers - Special Characters
- MID Function - Retrieve MailIDs
- Split Function: Split The Data Based On Space
- Extract Unmatched Records from two Data sets using SPLIT function
- Difference_Between_Two_Data_Sets and Create Add-in to convert into formula
- CSTR Function
- Concatenate Two Data sets with Duplicates and WithOut Duplicates Using Split Function
- Replace Blank Cells with UnderScrore
- Rearrange the Jumbled words in the same row using SPLIT Function
- Split The Sentence based on SPACE and segregate into multiple cells using SPLIT function
- Remove Duplcates and Concatenate with Previous Data
- Compare Two Data sets Using VLookup and Err Functions
- Compare Two Data sets Using VLookup and IFError Functions
- Difference between two data sets - highlight Mismatch
- Comparision between two data sets or columns using FIND Function
- Compare Two worksheets and highlight the Mismatch
- ActiveWindow Properties
- Border Alignment Formatting Options
- Provide Borders to the Range
- BorderAround Method Of Range Object
- Color Alternate columns Rows
- Number Formatting
- Print Numbers
- Name Numerology
- Print Roman Numbers
- AGE Calculation
- Print ODD EVEN PRIME Numbers
- Words For Alphabhets
- Display Alphabhets Vowels Consonents
- Create Table
- Print Numbers In HTML Document
- Create Tables In HTML Document
- Pronounce Numbers And Alphabet Words
- Convert Numbers Into Words
- Convert Numbers Into Number Names
- Messagebox
- Inputbox
- Create Yearly Calendar using Personal Photograph
- Large Data Analysis
- Row and Column slicing Using Combo Box
- Bifurcate Annual Data into Month Wise
- Large Data Analysis: Create Chart Based On ListBox Selection In Userform
- Large Data Analysis - Prepare Stat And Create Charts
- Structure The UnStructured Data
- Projects Segregation
- Retrieve HMTL Files from a Folder
- Yahoo Downloads
- Autofilter Based on Date Ranges
- Day Wise Dates
- Required Data
- ShortCut Keys
- Miscellaneous Programs
- Calendar
- Hide and Unhide the Rows through CHECKBOX selection
- Sum the Underlying values of Primary and Child IDs
- Arrange Hierarchy Order In Organisation Based On IndentLevel By Using VBA Macros In Excel
- Age Calculation - Create Addin - Create Custom Formula
- Stock Maintenance Template For Shop Keeper
- Create New Year Calendar 2023
- Create New Year Greeting card 2023
- Data Extraction From Text File To Excel
- Import the Data from Text File To Excel using -- Entire Data -- Regular Expression
- Data Extraction From Word Document To Excel
- Export the data from Excel to Word
- Create Anchor Tag in Word Document
- Create Code for Google Search
- Data Extraction From WebSite To Excel Through Web Scrapping
- Web Scrapping From Yahoo
- Open Or Connect Gmail Account
- Late Binging Vs Early Binding
- Extract The Price for Single Scrip from Yahoo Finance
- Extract Company Names by Placing Alphabets in Search Box of Yahoo Finance Web page
- Extract the Market Data From Yahoo Finance and Prepare charts
- Extract Financials from Yahoo Finance
- Extract Historical Pricing From Yahoo Finance
- Extract Phone details from FLIPCART - Single Page
- Extract Phone details from FLIPCART - Multiple Pages
- Data Extraction From Access Database To Excel
- Insert Values into Excel Access SQL Database
- OpenDatabase Method Of Workbooks Object
- Data Extraction From SQL Database To Excel
- Export the Data from Excel to SQL Database
- Create Insert Update Delete - CURD Operations With Excel by Establishing ADODB Connections
- Export The data from Excel to Sequel Database(SQL) - Part - 1
- Create Stored Procedure and Generate Report - Part - 2
- Create Stored Procedure with Variables and Generate Report - Part - 3
- Excel to Sequel(SQL) consolidated Queries and Create Website
- Data Extraction From Excel By Considering Excel As Database
- Consolidated Sequel Queries through ADODB Connection by Considering Excel as Database
- Query Tables
- HTML Concepts in Outlook
- Send Email To Single User
- Send Emails to Multiple MailIds
- Export Table or Tabluar Data from Excel To Outlook
- Export The Data From Excel to Outlook - Template
- Export the Data from Excel to Outlook
- Usage of Span Tag - To format the required content
- Export The data from Excel to Powerpoint
- Transfer Specifed Range Data from Excel to Power Point
- Export The Images from Predefined Folder path to PowerPoint(PPT)
- Export The Charts from Excel to PowerPoint
- Name Manager
- Create_Table
- Consolidation of Workbooks after selecting workbooks and worksheets through List box
- Consolidation of Worksheets using Listbox
- Segregation Of Columns Data into Multiple Worksheets
- split the data based on filter column into Multiple worksheets and workbooks
- Blank Cells
- Duplicate Values
- Insert Rows Columns
- Remove BlankCells
- Conditional Formatting
- Data Comparision
- Creation Of sheets based on Data exists in cells Using For - Next, For Each, Do While, Do Until Loops
- Collection Of Sheet Names Using For - Next, For Each, Do While, Do Until Loops
- Creating Of Sheets by adding new workbook
- Creation Of Sheets Daywise In a Selected Month To Enter The Daily Schedule
- Create Worksheets based on Month Names
- Create Attendance Sheets
- Retrieve Sheets count in Workbook
- Delete Movement_Of_Sheets
- Copy Required Sheet N Number Of Times
- Ensure whether a cell consits of Numeric or not - Change Event
- Ensure whether a cell consits of Text or not - Change Event
- Validate A Cell By Using Change Event And IsNumber Function
- Environ
- STOP - Provides the Break Point programatically
- Craete new tab and add the macro to the ribbon
VBA Introduction
Declare Varaible - Data Types - Scope of Variable
Conditional Statements
Logical Operator
Application Object
Workbooks Object
Range Object
Programs with Shapes and Picture
Autofilter
Lookup Functions
Dictionary
Array
Module
Autofill
Pivot Table
Controls
Ribbon
File System Object
Loops Introduction
Properties
Methods
Worksheet Functions
Custom Functions
Functions
Comparision between two data sets
Active Widnow
Formatting
Kids Zone
MessageBox
Projects
Interaction With TextFile
Interaction With Word Document
Interaction With Websites - Web Scrapping
Interaction With Access DataBase
Interaction With Sequel(SQL) DataBase
Interaction with Excel as Database
Interaction With OutLook
Interaction with PowerPoint
Name Manager
Table
Consolidation - Workbooks and Worksheets
Program with Cells
Conditional Formatting
Programs with Worksheets
Validate a Cell
System Related Data
Debugging The Code
Customize the ribbon
Quick Reference
Hi Everyone,
Welcome to VBA Macros Tutorial. This Tutorial provides comprehensive knowledge on VBA Macros to the user.
Hope it enhances your coding skills. If you like this web page kindly Share this to your near and dear.
I Prepared this content as per my level of knowledge, if any changes required kindly bring to my notice. Thanks for visiting this web page
Thanks,
Pavan Kumar Gundlapalli