Macros & Excel VBA

How to Set Option Button Value in Excel VBA (4 Easy Steps)

The Option button or radio button is an important feature in the UserForm. We can set the option button value and use VBA macro to execute various ...

How to Spell Number in Taka in Excel (With Easy Steps)

Every country has its own significant currency that is used for regional banking, business and educational purposes. Microsoft Excel has become a ...

How to Make a Calculate Button in Excel (with Easy Steps)

Users can use the F5 key or a Form Control Button to run a macro to calculate operations within worksheets. In this article, we demonstrate the ...

How to Use VBA Code for Submit Button in Excel (with Easy Steps)

While working in Microsoft Excel sometimes we need to use VBA code for the submit button in Excel. We can easily do that in Excel. This is also a ...

How to Clear Contents of a Sheet with Excel VBA (5 Examples)

One of the advantages of using spreadsheet software like Microsoft Excel instead of a handwritten one is the reusability. Sometimes you need to clear ...

How to Use Spell Number in Excel (2 Suitable Examples)

Sometimes you need to convert the number into a text value. In that case, you can use the spell number function in Excel. Though it is not a built-in ...

How to Spell Number in Rupees in Excel (With Easy Steps)

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using excel tools and features. There are many default ...

How to Spell Number in Dirhams in Excel (2 Handy Ways)

If you are looking for ways to spell a number in Dirhams in Excel, then you are in the right place. So, let’s start with the main article to know the ...

[Solved] Spell Number Not Working in Excel

The article will show you how to solve the spell number not working problem in Excel. Basically, Excel doesn’t have any built-in function to spell a ...

How to Highlight Active Row in Excel VBA (2 Suitable Examples)

This article illustrates how to highlight the active row using Excel VBA. Assume you have a large dataset with many columns. Then you may lose track ...

How to Open Workbook as Read-Only with Excel VBA

Naturally, we may need to open the file from a parent Excel file using VBA as a read-only form. For the reason of keeping the original file intact. ...

How to Apply Formula to Entire Column Using Excel VBA

In this tutorial, I am going to show you 3 simple methods on how to apply a formula to an entire column using excel VBA. These methods will save a ...

How to Find Lookup Value in Array in Excel VBA (2 Easy Ways)

Most likely, you’re familiar with lookup value in an array in Excel. What if you need to do the same task using Excel VBA? Sounds interesting. ...

Excel VBA to Clear Contents of Named Range (3 Macro Variants)

The article will show you how to clear the contents of a Named Range in Excel VBA. If your dataset contains Named Ranges and you need to change the ...

How to Declare Array in Excel VBA (3 Easy Ways)

If you want to run a VBA code in Excel, then you first have to declare array. However, if you want to declare arrow in VBA, then you have landed in ...

ExcelDemy
Logo