In this tutorial we will see how to create a user form using VBA and dynamic combo boxes to it. The input sheet contains a number of drop downs with varying number of options in each, as seen below: Using VBA, we will create two
In this article we will look at how to find duplicate entries across columns using Excel VBA. Consider you have 3 columns of data with few duplicate rows as seen below: And you need to highlight the rows that are not unique. As there is no
In this article we will see how to copy data from multiple Excel workbooks and paste it to a new Excel Workbook. Consider you have three Excel workbooks with data in a single sheet with the same name. The range from which data is to
In this article we will look at how to copy values from multiple worksheets to other worksheets within the same file based on a condition using Excel VBA. Consider you have monthly sheets (named Jan, Feb, Mar and so on) that contain stock prices as
“Next Without For” Compile Error is a very common compile-time error in Excel VBA. It implies that a Next statement must always have a preceding For statement that matches. If a Next statement is used without a corresponding For statement, this error is generated. Let us look at
In this article we will see how you can search for a string in a PDF file and highlight it using Excel VBA. We will look at two examples, one that works with Acrobat Reader and a second that should be used if you have
In this article, I will show you various ways to copy and paste data using Excel VBA. The paste method is one of the most commonly used methods in Excel. There are two methods for pasting data, namely “Worksheet.Paste” and “Range.PasteSpecial”. Let us start with
The Case statement is a very common and useful function used in VBA. Using the case statement, you can run one of several groups of statements, depending on the value of an expression. It is an easier way to write multiple IF-THEN-ELSE statements. In this article, we
In this article we will look at the Range.AutoFilter method of Excel VBA. It is a very powerful tool that is not used as often as is should be by programmers. Suppose you have a list of data tagged by month want to do certain operations
The ListObjects property of the Worksheet object returns the ListObjects collection. The ListObjects collection contains all the list objects on a worksheet. The ListObject object is a member of the ListObjects collection. Each ListObject object represents a table (previously known as a list) in the worksheet. An
