EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • All Courses
    • All Specializations
  • Blog
  • Enterprise
  • Free Courses
  • All Courses
  • All Specializations
  • Log in
  • Sign Up

Home VBA VBA Resources

Mastering VBA Resources

Automation is the need of the hour, so Excel is behind with this because we have Visual Basic For Applications.

VBA is very helpful in automating routine task and save a tremendous amount of time. In this blog, you will learn some useful concepts in the context of VBA Macros. Right from basic, some of the advanced stuff is included in this blog.

VBA Array Functions

15 RESOURCES

  • VBA Split String into Array
  • VBA LBound
  • VBA Filter
  • VBA Dynamic Array
  • VBA ReDim Array
  • VBA Declare Array
  • VBA ReDim
  • VBA Collection
  • VBA Join
  • VBA UBound
  • VBA Array Length
  • VBA ArrayList
  • VBA Sort
  • VBA Dim
  • VBA Arrays

VBA Coding

24 RESOURCES

  • VBA Set Range
  • VBA ByVal
  • VBA XML
  • VBA XLUP
  • VBA Variable Range
  • VBA Goal Seek
  • VBA Variable Types
  • VBA Public Variable
  • VBA Variant
  • VBA SUB
  • VBA ByRef
  • VBA Variable Declaration
  • VBA Global Variables
  • VBA Option Explicit
  • VBA Code
  • VBA Class Module
  • VBA END
  • VBA Exit Sub
  • VBA Call Sub
  • VBA Clear Contents
  • VBA Enum
  • VBA Data Types
  • VBA Long
  • Excel VBA - Ms Excel Is Tremendously

VBA Conversion Functions

10 RESOURCES

  • VBA CDEC
  • VBA CLng
  • VBA CInt
  • VBA Double
  • VBA Val
  • VBA CDate
  • VBA CHR
  • VBA CDBL
  • VBA CSTR
  • VBA Value

VBA Date & Time Functions

12 RESOURCES

  • VBA Format Date
  • VBA Month
  • VBA DateDiff
  • VBA Format Number
  • VBA Date Format
  • VBA DatePart
  • VBA DateSerial
  • VBA DateValue
  • VBA DateAdd
  • VBA Date
  • VBA TIMER
  • VBA Time

VBA Error Handling Functions

11 RESOURCES

  • VBA IsError
  • VBA Type Mismatch
  • VBA On Error GoTo 0
  • VBA On Error Goto
  • VBA On Error Resume Next
  • VBA Error Handling
  • VBA OverFlow Error
  • VBA Subscript out of Range
  • VBA 1004 Error
  • VBA IFError
  • VBA On Error

VBA File & Directories Functions

10 RESOURCES

  • VBA Get Cell Value
  • VBA Solver
  • VBA FreeFile
  • FileCopy in VBA
  • VBA Write Text File
  • VBA GetOpenFileName
  • VBA FileDialog
  • VBA DIR
  • VBA Check File Exists
  • VBA Delete File

VBA Information Functions

16 RESOURCES

  • VBA Environ
  • VBA Name Worksheet
  • VBA ScreenUpdating
  • VBA Editor
  • VBA Delete Sheet
  • VBA Unprotect Sheet
  • VBA Protect Sheet
  • VBA Rename Sheet
  • VBA Workbook Open
  • VBA Worksheets
  • VBA Cells
  • VBA Activate Sheet
  • VBA Workbook
  • VBA ISNULL
  • VBA IsEmpty
  • VBA Active Cell

VBA Input & Output Functions

8 RESOURCES

  • Narrow Margin Using Macros
  • VBA Login
  • VBA Debug Print
  • VBA Send Email From Excel
  • VBA Close UserForm
  • VBA UserForm
  • VBA Print
  • VBA Outlook

VBA Logical Functions

21 RESOURCES

  • VBA AND
  • VBA With
  • VBA Not
  • VBA Do Loop
  • VBA DoEvents
  • VBA IF Statements
  • VBA Selection
  • VBA IF Not
  • VBA OR
  • VBA Boolean
  • VBA Operators
  • VBA For Each Loop
  • VBA Like
  • VBA Do Until Loop
  • VBA Break for Loop
  • VBA Select Cell
  • VBA While Loop
  • VBA Do While Loop
  • VBA Else If
  • VBA Select Case
  • VBA Loops

VBA Lookup & Reference Functions

21 RESOURCES

  • VBA Selecting Range
  • VBA Resize
  • VBA LOOKUP
  • VBA Insert Row
  • VBA Hide Columns
  • VBA Selection Range
  • VBA Columns
  • VBA OFFSET
  • VBA Hyperlink
  • VBA Name
  • VBA Last Row
  • VBA Named Range
  • VBA Range Cells
  • VBA Insert Column
  • VBA Union
  • VBA Delete Column
  • VBA Delete Row
  • VBA Transpose
  • VBA Match
  • VBA Range
  • VBA VLOOKUP Function

VBA Math & Trig Functions

11 RESOURCES

  • VBA Square Root
  • VBA Randomize
  • VBA Intersect
  • VBA Random Number
  • VBA RoundUp
  • VBA INT
  • VBA Round
  • VBA Integer
  • VBA IsNumeric
  • VBA MOD
  • VBA Number Format

VBA Message Functions

10 RESOURCES

  • VBA Input
  • VBA Msgbox Yes No
  • VBA Text
  • VBA Message Box
  • VBA InputBox
  • VBA Comment
  • VBA Block Comment
  • VBA TextBox
  • VBA List Box
  • Excel VBA MsgBox

VBA Object functions

7 RESOURCES

  • VBA Create Object
  • VBA Object Required
  • VBA Me
  • VBA GetObject
  • VBA FileSystemObject (FSO)
  • VBA Set
  • VBA Object

VBA Program Flow Functions

3 RESOURCES

  • VBA Switch Case
  • VBA IIF
  • VBA Switch

VBA Statistical Functions

4 RESOURCES

  • VBA Max
  • VBA Counter
  • VBA COUNTA
  • VBA Count

VBA String and Text Functions

27 RESOURCES

  • VBA Replace String
  • VBA String Array
  • VBA String Comparison
  • VBA SubString
  • VBA Concatenate Strings
  • VBA Right
  • VBA StrConv
  • VBA MID
  • VBA Format
  • VBA Length of String
  • VBA Constants
  • VBA InStrRev
  • VBA ASC
  • VBA Find and Replace
  • VBA StrComp
  • VBA Concatenate
  • VBA LCase
  • VBA UCASE
  • VBA InStr
  • VBA Left
  • VBA RegEx
  • VBA Split
  • VBA String
  • VBA Replace
  • VBA Case
  • VBA Find
  • VBA TRIM

VBA Tips

36 RESOURCES

  • VBA Interview Questions and Answers
  • VBA Return
  • VBA Project Password
  • VBA Web Scraping
  • VBA RGB
  • VBA PasteSpecial
  • VBA Save Workbook
  • VBA SendKeys
  • Programming in Excel
  • VBA Examples
  • VBA Macros
  • VBA Refresh Pivot Table
  • VBA AutoFill
  • VBA Pivot Table
  • VBA Pause
  • VBA Conditional Formatting
  • VBA Paste Values
  • VBA Dictionary
  • VBA Charts
  • VBA Save As
  • VBA Tutorial
  • VBA Borders
  • VBA PowerPoint
  • VBA Font Color
  • VBA Sleep
  • VBA Remove Duplicates
  • VBA Copy Paste
  • VBA Paste
  • VBA Wait
  • VBA Color Index
  • VBA GoTo
  • VBA Function in Excel
  • VBA Macros in Reporting & Analysis
  • Popular Visual Basic Chart in Another Sheet- Excel VBA
  • Amazing Visual Basic - Simple Graphs With Dynamic Input
  • Excel VBA Macro

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Company
  • About us
  • Alumni Speak
  • Contact Us
  • Log in
  • Sign up
Work with us
  • Careers
  • Become an Instructor
EDUCBA for Enterprise
  • Enterprise Solutions
  • Explore Programs
  • Free Courses
  • Free Tutorials
  • EDUCBA at Coursera
  • EDUCBA at Udemy
Resources
  • Blog
  • Self-Paced Training
  • Verifiable Certificate
  • Popular Skills Catalogue
  • Exam Prep Catalogue
Popular Categories
  • Lifetime Membership
  • All in One Bundles
  • Featured Skills
  • New & Trending
  • Fresh Entries
  • Finance
  • Data Science
  • Programming and Dev
  • Excel
  • Marketing
  • HR
  • PDP
  • VFX and Design
  • Project Management
  • Exam Prep
  • Learning Paths @ $49
  • All Courses
  • Terms & Conditions
  • Disclaimer
  • Privacy Policy & Cookie Policy
  • Shipping Policy

ISO 10004:2018 & ISO 9001:2015 Certified

© 2026 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

EDUCBA
Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Web Development & many more.

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

🚀 Limited Time Offer! - 🎁 ENROLL NOW