VBA (Visual Basic for Applications)

VBA (Visual Basic for Applications)


VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs.
  • Write Data to Worksheet Cell in Excel VBA          
  • Writing and Reading Excel Worksheet Cells Ranges in VBA           
  • Read or Get Data from Worksheet Cell to VBA in Excel  
  • Select Cell Range in Excel VBA   
  • Copy Data from One Range to Another in Excel VBA       
  • Clear Cells in Excel Range Worksheet using VBA
  • Change Font Color in Excel VBA
  • Change Font to Bold in Excel VBA            
  • Change Text Case – Upper Lower in Excel VBA: Solution               
  • Change Background Color of Cell Range in Excel VBA      
  • Merge UnMerge Cell Range in Excel VBA             
  • Add Clear Comments in Excel VBA          
  • Change Row Height and Column Width using Excel VBA
  • Delete Rows and Columns in Excel VBA
  • Hide UnHide Columns in Excel Worksheet using VBA
  • Hide-Unhide-Rows - Case Study Example            
  • Hide-Unhide-Columns - Case Study Example     
  • Inserting-Columns - Case Study Example             
  • Inserting-Rows - Case Study Example
  • Last-Column-with-Data - Case Study Example    
  • Last-Column-with-Data-in-a-row - Case Study Example 
  • Last-Row-with-Data - Case Study Example          
  • Last-Row-with-Data-in-a-Column - Case Study Example
  • Create New Workbook in Excel VBA       
  • Run a Macro Automatically on Opening Excel Workbook               
  • Open and Close Excel Workbook using VBA        
  • Save Workbook Using Excel VBA to Specific Folder          
  • Protect and Unprotect Excel Workbook using VBA          
  • Protect and UnProtect Worksheets in Excel VBA              
  • Hide UnHide Worksheets in Excel VBA  
  • Delete Worksheet in Excel VBA
  • Copy Data from one Worksheet to Another in Excel VBA              
  • Activate Workbook Or Worksheet in Excel VBA 
  • Get Active Workbook or Worksheet Name Path Full Name in Excel VBA
  • Hyperlinks in Excel VBA – Explained with Examples!.xlsm             
  • Excel Chart VBA Examples and Tutorials
  • Chart-VBA-Examples
  • Send Chart To OutLook

Duration : 30 DAYS.

Certification : DATAPOINT COMPUTERS.