Want to become an expert in VBA? So this is the right place for you. This blog mainly focus on teaching how to apply Visual Basic for Microsoft Excel. So improve the functionality of your excel workbooks with the aid of this blog. Also ask any questions you have regarding MS Excel and applying VBA. We are happy to assist you.


Click to see the post

Number of rows in Excel 2013
Best way to get the last row of any column of the excel sheet
Copy and paste a range
Get a position of a character in a string
Find last cell filled with data in a specific column
How to use RGB color system
Number of columns in excel 2010 - An important fact about excel 2010
Best way to get column number of last cell having data
Check whether font is bold in a cell
How to use sum function in VBA
How to increment days, weeks, months etc.
How to put outlines around the cells
Populating 3 combo boxes
Open save as dialog box with a file name
Cell address of a cell having a specific data
Delete a row, rows, column or columns
How to get a discription of an error
Function to returns column name from col number
Add names of all open workbooks to a combo box list
Add data set to next empty row of a excel database
Clear the value of a text box when click on it
Get path of a workbook
Dealing with word documents
Replace string inside a string by another string
Save excel file as CSV file
Open a closed work book
Call each and every sheet of a workbook
Browse file and put path+name and name in two labels
reference workbooks and sheets Explicitly
Find last row having data in a certain column
Add work sheet with a name
Populate combo box with sheet name of opened work book
Find function
Date format issue (How to solve)
Sort Function
Finding a specific file from a folder
Open files in a specific directory (folder)
VBA - Error 400
Open and read text file
Web Scraping - Basics
How to add @ or = sign
Download a file from url using VBA
Excel 2013 Pivot tables
Check whether folder exist and create if it is not
Getting started with Visual Basic Editor in Excel
How to show the Developer tab in Excel 2013
SUMIF function
Open an outlook email and populate the body of the email
Import Data from Word Table to Excel sheet
Is Letters Function - Check Whether a String Consist of Only Letters
Insert an Image to Excel Worksheet using VBA
Split Function
Insert several images to a worksheet using VBA
How to transpose Values in a column to a row using VBA
Add Data Analysis Command to Data tab in Excel 2013
Insert Text Box to a worksheet
How to Use Scroll Bar in Userform
Fixed Size Arrays in VBA
Multidimensional Arrays in VBA
Dynamic arrays in VBA
Quick Multidimensional Array from Excel Range
Quickly Write Multidimensional Array to Excel Range
Calculate With Arrays
Re-size Dynamic Arrays
Transposing an Array in VBA
Use of On Error GoTo 0
Detect Operating System
Split a Long Row of Data Into Multiple Rows
Useful References for VBA Web Scraping
Determine whether characters inside a cell are bold or regular
Web Scraping Techniques
Web Scraping - Collecting Data From a Webpage
Web Scraping - Collect Options Inside Drop-down Lists
Upper Case, Lower Case and Proper Case
VBA Web Scraping - Identifying Disabled Dropdowns
Pause Program Execution In VBA - Sleep and Wait Functions
Create Excel Timer Using VBA
Add Button To Excel Worksheet
Change attributes of controls inside VBA userforms in easier way
How to scroll a web page number of pixels
How to use Find and replace function in VBA
Add Textbox to Excel Worksheet
Use Textbox to Input Date in VBA
Add a Command Button to an Excel Sheet
How to Add Power Query to Excel Ribbon
How to Find Out Bit Version of Excel
Reference Dynamic Userform Name
Concatenate using VBA
How To Remove PERSONAL.XLSB file
Create Lines With VBA
Create and Format a Table
An Excel VBA Macro to Save a Workbook Automatically When Closing
How to Pause for Specific Amount of Time in Excel VBA
How to Set the Location, Width and Height of an Inserted Image in Excel VBA
Paste Clipboard Content to Excel Sheet Using VBA
How to Sum Values in Excel
How to Create a New Workbook from Existing Excel Sheet in Excel VBA
Create new workbooks from each and every worksheet in your workbook | Excel VBA
How to Read, Write, Delete and Move excel comments
Hide And Unhide Worksheets Using VBA
How to Use Excel ABS Function
Calculate absolute value in VBA (Abs function)
How to Find RGB Value of Fill Color of Any Cell
If Then Statement in VBA
If Then Else Statement (Excel VBA)
Remove Characters From Left or Right of a String
Loop Through All the Controls of a VBA UserForm
Remove Conditional Formatting From an Excel Sheet (VBA)
How to Find Names of Objects in a PowerPoint Slide
Controlling PowerPoint from Excel - VBA
Add Hyperlinks in PowerPoint - Excel VBA
Missing Reference - Excel VBA
Save an Excel Sheet as PDF
Convert an Excel Sheet to PDF Using VBA
How to create a line chart automatically - Excel VBA
How to Print Automatically (Excel VBA)
How to remove duplicates in excel
Sum Function (Worksheet)
Hide Worksheet Tabs in Excel
Change Font Color in VBA Editor in MS Excel
VBA Fix Function
How to Check If a Value Has Decimal Places
VBA Int function
Convert an Entire Workbook to a Single PDF File
Save a Workbook as a Single PDF Using VBA
How to use preserve keyword in arrays
How to Add Additional Controls in Excel VBA
DateSerial Function (VBA)
BESSELI Function
BESSELJ Function
Convert Multiple Excel Sheets to a Single PDF File Manually
Create line chart with multiple series using Excel VBA
Find the name of a chart in Excel
How to find the name of an active chart using VBA
Formatting Excel Line Charts Using VBA
Copy Excel Line Chart (Graph) Using VBA
getElementsByClassName Vs getElementById
When to use the getElementsByClassName method
How to Show Immediate Window in VBA Environment in Excel 2013
Type Mismatch Error (Run Time Error 13) When Converting to Double
CDbl - Type Mismatch Error When Textbox is Empty (How to Solve)
Using the IsNumeric Function to Avoid CDbl Type Mismatch Error
IsNumeric Function (VBA Function)
Using Val Function to Avoid CDbl Type Mismatch Error
Record a Macro in Excel
Add an Excel Macro to a Workbook
How to Use For Each Next in Excel VBA
VBA With Statement (Excel VBA)
Microsoft Edge
.frx File
Extract Data From a .msg File to an Excel Sheet
Create an Excel CSV File Having More Than 1048576 Rows of Data
Return a Result From a Custom VBA Function
How to add labels to VBA Userforms
How to Add Textboxes to VBA Userforms
How to Format Label Text in VBA Forms (To Give Professional Look)
Convert an Excel File to CSV Using VBA
Save Each Excel Worksheet To Separate CSV File Using VBA (Worksheet Name As File Name)
How To Quote All Cells Of A CSV File
How To Run A Macro In Excel
Get Selected Rows Using VBA Macro
How To Protect A Worksheet In Excel
Lock Only Specific Cells In An Excel Worksheet
How To Remove Gridlines In Excel
Personal Macro Workbook in the startup folder must stay open for recording - (How to solve)
How To Switch Rows And Columns In Excel
How To Record Macros In Personal Macro Workbook
Show Userform Automatically When Opening Excel File
Add Data to a Protected Sheet Automatically Using VBA
Show Message Box (Msgbox) For a Few Seconds

Contact Form


Email *

Message *