Excel VBA

Home/Excel VBA

Excel VBA is the macro programming language available in the Excel and other MS office tools. It helps to automate the regular tasks, create the dashboards and build the tools to perform certain tasks.

Column Name to Column Number

Column Name to Column Number is nothing but converting Excel alphabetic character column name to column number. Most of the time while automating many tasks it may be required. Please find the following details about conversion of column name to column number. You can also say column string to column number. Or get alphabetic character to column number using Excel VBA.

Remove CheckBox on Worksheet or UserForm in Excel

We can remove or delete checkbox on the worksheet or userform using ‘Go To Special’ or ‘Select Objects’ or by turning on Design Mode in Developer tab. when we don’t want to place checkbox control on the worksheet or userform we removes from there. Please find the more details and screenshots for clear understanding about remove checkbox control in the following chapter.

Add CheckBox on Worksheet or UserForm in Excel

Add CheckBox on Worksheet or UserForm is using checkbox control and is used to specify or indicate binary choice. In this section we will see how to add single checkbox or multiple checkboxes on the worksheet or userform. Please find more details about add checkbox control in the following chapter.

Introduction to Collections in Excel VBA

Collection is an object contains group of objects having similar characteristics (with same properties and methods). For example,if you want to loop through all worksheets in a workbook, you can refer worksheets collection of the workbook and do whatever you want to do with that particular worksheet.

In this topic:
  • Introduction to Collections?
  • Collections in Excel VBA
  • Examples Macro File On Collections

By |August 25th, 2013|Excel VBA|1 Comment

ADO in Excel VBA – Connecting to database using SQL

ADO Stands for ActiveX Data Objects, is Microsoft’s Client-Server technology to access the data between Client and Server. ADO can’t access the data source directly, it will take help of OLE DB Provider to communicate with the data source. Most of the times OLE DB providers are specific to a particular Data Source Type. However, we have an OLE DB provider for ODBC, it is a general purpose provider with help of this ADO can access any Data source which can understand ODBC.

In this topic:
  • What is ADO?
  • What is Database?
  • What is SQL?
  • Practical Learning: Using ADO and SQL with VBA
  • Example File

Events in Excel VBA

Event programming is the most useful tool which helps to monitor specific user actions within Excel. For example, if the user Opening a Workbook, Selects a Worksheet, enters data into a Cell, or saves a Workbook, these actions are all Excel Events.

In this topic:
  • What Are Events?
  • What Are The Different Types of Events?
  • Practical Learning: Workbook_Open Event
  • Example File: Workbook Events, Worksheet Events and Form Events

By |August 11th, 2013|Excel VBA|6 Comments

Related pages

vba find last rowopen xlsx file with excel 2003duplicate records in excelhow to protect excel with passwordexcel merge tabsremove empty lines excelhow many rows and columns are in excelhow to get rid of blank rows in excelexcel macro enabled worksheetusing the sumif function in excellook up function in excelvba excel open excel fileexcel vba range functionproject portfolio management template excelhow to create sql query in excelms excel 2007 vlookupbar chart excel templatevba delete filesexcel count duplicate valuessql data manipulation commandsms access vba tutorial pdfbuilding macros in excel 2010lookup vba excelhow do you sort columns in excelexcel vba chr functionchart wizard excel 2010how to remove duplicate cells in excel 2010excel automatic sorthow to eliminate duplicate records in excelexcel vba check if cell is emptysas training for beginnersvloopup examplehow to delete activexexcel advanced learningunderstanding macros in exceldynamic vlookuphow do you do a tick in excelvb adoexcel remove blankhow to dynamically change excel chart datamicrosoft office meeting minutes templateunlocking excel spreadsheethow to program macros in excelexcel vba close userforminsert row on excel3d graph in excelmacro in xlsactivex listboxexcel template checklistoption buttons in excelexcel vba worksheet functionsimple gantt chart template excel 2010vlookup with sumcool excel dashboardsgantt chart free downloadvba workbook closeexcel formula sort alphabeticallyhow to delete macros in excelsample excel dashboard templatesactivesheet cellsexcel vba checkboxdll dmlhow to put title on excel graphvba selection.sorthow to hide a column in excelexcel calculate sheet shortcutcommand to insert row in excellookup in excel 2007 with exampleexcel lookup functionsexcel tutorial charts and graphsvba instringhow to learn formulas in excelexcel sumifs functionvlookup in excel 2007 with example in excelvba interior.colorexcel password template