Similar Topics

Web Technologies32.1K+ articles

DSA20.0K+ articles

Python19.6K+ articles

Experiences15.8K+ articles

Interview Experiences14.3K+ articles

School Learning11.1K+ articles

JavaScript9.9K+ articles

Java9.3K+ articles

Misc7.7K+ articles

Mathematics5.6K+ articles

Excel-VBA

60 posts

How to Automate Repetitive Tasks in Excel Without VBA Macros

Last Updated: 23 July 2025

Automating repetitive tasks in Excel can save you significant time and effort, even if you're unfamiliar with VBA macros. Excel offers built-in tools and features that all...read more

article_image

Excel Transpose: Convert Rows to Columns

Last Updated: 22 August 2025

The Transpose feature in Excel lets you switch rows into columns and columns into rows. It’s useful when your data is organized horizontally but you need it vertically.Tra...read more

article_image

Excel-functions

How to Debug a User Defined Function in Excel VBA

Last Updated: 02 September 2025

Debugging a User Defined Function (UDF) in Excel VBA can feel like a detective mission searching for clues to fix issues in your code. When a custom function doesn’t deliv...read more

article_image

Excel - Advanced

Geeks Premier League 2023

How to Calculate Partial Correlation Matrix With Excel VBA?

Last Updated: 13 June 2023

Correlation is the way to measure the relation between two variables. The value of the correlation lies between -1 to 1. If the value is greater than 0 then both the value...read more

article_image

What Does the Number in the Addchart2 VBA Macro represent?

Last Updated: 14 June 2023

A chart or graph can be made in an Excel spreadsheet by using the AddChart2 VBA macro. The desired chart type or style is indicated by the number in the AddChart2 VBA macr...read more

Workbook and Worksheet Object in Excel VBA

Last Updated: 30 January 2023

Excel VBA is an object-oriented programming language, which means in excel every component is an object. The superset of all the objects of excel is the excel application ...read more

article_image

Technical Scripter 2022

How to Create Charts in Excel Using Worksheet Data and VBA?

Last Updated: 01 February 2023

Excel is an important software provided by Microsoft Corporation. This software belongs to one of the major software suites Office 365. In this software suite, there are o...read more

article_image

Technical Scripter 2022

Debugging VBA Code in Excel

Last Updated: 23 July 2025

When we use VBA to write code in excel or when we any programming language to write code we may encounter errors that need to be analyzed, checked, and fixed. To overcome ...read more

article_image

Technical Scripter 2022

Basic Object Model in Excel VBA

Last Updated: 27 January 2023

VBA stands for visual basic for application. Excel VBA is an object-based programming language, it is used while recording a macro i.e., it uses the idea of Encapsulation ...read more

article_image

Technical Scripter 2022

How to Get a List of User Defined Functions in Excel VBA?

Last Updated: 22 February 2023

Microsoft provides many built-in functions to speed up your work in Excel. However, you can technically create functions using VBA coding called "user-defined functions" (...read more

Technical Scripter 2022

Excel-functions

How to Create an Input Box With Multiple Inputs in Excel Using VBA?

Last Updated: 23 July 2025

The Input Box is a dialogue box that helps users to take a value and do later computations according to the entered value. The input box is similar to the message box, but...read more

article_image

Technical Scripter 2022

How to Create Dynamic Range Based on Cell Value in Excel VBA?

Last Updated: 11 March 2023

Dynamic ranges in excel VBA provide us with the flexibility to define ranges beyond the specific values. The dynamic range enables the program to perform transformation an...read more

article_image

How to Mask Password in VBA Excel Input Box?

Last Updated: 09 September 2025

Passwords are crucial for user authentication in applications, combining letters, numbers, and symbols to verify identity. In Excel VBA, masking passwords (e.g., displayin...read more

article_image

Technical Scripter 2022

Sub Procedure in Excel VBA

Last Updated: 09 September 2025

A Sub Procedure in VBA (Visual Basic for Applications) is a block of code that performs an action. It starts with a Sub statement and ends with an End Sub statement. Sub p...read more

article_image

How to Insert and Run VBA Code in Excel?

Last Updated: 02 September 2025

In Excel VBA stands for (Visual Basic for Application Code) where we can automate our task with help of codes and codes that will manipulate(like inserting, creating, or d...read more

article_image