EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

VBA Resources

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 Arrays
  • VBA ReDim
  • VBA Dim
  • VBA Sort
  • VBA Array Length
  • VBA ArrayList
  • VBA UBound
  • VBA Join
  • VBA Collection
  • VBA Declare Array
  • VBA ReDim Array
  • VBA Dynamic Array
  • VBA Filter
  • VBA LBound
  • VBA Split String into Array

VBA Coding

24 RESOURCES

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

VBA Conversion Functions

10 RESOURCES

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

VBA Date & Time Functions

12 RESOURCES

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

VBA Error Handling Functions

11 RESOURCES

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

VBA File & Directories Functions

10 RESOURCES

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

VBA Information Functions

16 RESOURCES

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

VBA Input & Output Functions

7 RESOURCES

  • VBA Outlook
  • VBA Print
  • VBA UserForm
  • VBA Close UserForm
  • VBA Send Email From Excel
  • VBA Debug Print
  • VBA Login

VBA Logical Functions

21 RESOURCES

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

VBA Lookup & Reference Functions

21 RESOURCES

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

VBA Math & Trig Functions

11 RESOURCES

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

VBA Message Functions

10 RESOURCES

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

VBA Object functions

7 RESOURCES

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

VBA Program Flow Functions

3 RESOURCES

  • VBA Switch
  • VBA IIF
  • VBA Switch Case

VBA Statistical Functions

4 RESOURCES

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

VBA String and Text Functions

27 RESOURCES

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

VBA Tips

35 RESOURCES

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

Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign In
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA
Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Watch our Demo Courses and Videos

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

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

Special Offer - All in One Excel VBA Bundle (120+ Courses, 500+ hours of Videos) Learn More