There are 2 types of arrays available in VBA. Single Dimensional Array: Single Dimensional array is used more often in the VBA. An array uses only one index. Multi-Dimensional Array: If an array has more than 1 dimension is called Multi-Dimensional Array.
Connection Objects are used to provide a connection between Excel and Databases with the help of ADODB Objects. So, we can interact with the database and can use the SQL queries to fetch the data from the database. ADO stands for, ActiveX Data Objects.
Goal Seek – is used to achieve your goal by changing the dependent value. Ex: If you have taken a personal loan, and if you can able to pay the EMI of 6K instead of 10K, how many months do you need to close your personal loan?