A spreadsheet application, designed by Microsoft, Ms-Excel is one of the most popular applications with features like pivot tables, graph, and calculations. It also supports a macro programming language called VBA (Visual Basic for Applications).
You can use the FolderExists() method in VBA Excel to check if a particular folder exists in a computer or not. FolderExists returns a Boolean true or false and it’s from the FileSystemObject class in ...
You can use the FileSystemObject in VBA to read and write data to an external text file from Excel. The FileSystemObject provides all necessary methods and properties that would help VBA developers to ...
You can use the ADDRESS function in Excel to get the address of a particular cell in your worksheet, by providing the function a row and column number. I am going to show how you can use the ...
You can populate a ComboBox in Excel dynamically with data extracted from various sources, such as an SQL Server database. The source can also be a web page, like a Select Dropdown list. I am sharing ...
I have previously shared a post that explained how to create multiple charts in Excel using worksheet data and VBA. Now, you can export these charts to other applications such as PowerPoint for ...
You can create and add controls at runtime in Excel UserForms. Some controls take data as input, some allow you to select or choose and there are button controls, which specifically perform a task on ...
I am sharing a simple VBA example here, which explains how easily you can insert or add a new row automatically in between existing rows in your Excel worksheet, on the click of a button. ...
You can easily add multiple controls to a UserForm in Excel, simply by dragging and dropping the controls from the toolbox on to the form. Do you know you can create UserForm controls at runtime? ...
Use of date and time is common in Excel and we often add a column or two showing date in our worksheet. We use dates in our reports, day-to-day transactions and more. Sharing a formula ...
You can dynamically hide or show an entire column or multiple columns in Excel using a simple VBA macro. Here in this post I am sharing an example where a macro will hide and show a column when someon ...
