You can create a Custom function in VBA in Microsoft Excel by following these steps: For example, to create a function called “MyFunction,” you would type the following: For example, to create a function that adds two numbers together, you …
Lesson#173: Steps to make a Custom function in VBA Read more »
Hello friends! How are you? Just working on a simple thing. I was making some easy formulas to get color code in Excel. Just like if you color a cell then this formula will break the R, G, and B …
Hello Guys! After a long time, I returned with a new lesson. Today I am going to discuss with you how to make a simple function in VBA. The VBA editor opens huge possibilities to make our Excel sheets into …
Lesson#146: How to make a simple function in VBA | How to add custom formula in Excel Read more »
An easy and simple trick to make a color picker will be shown here. Here I have made a color palette by coloring different cells with different colors. This palette allows us to pick different types of colors by selecting …
Lesson#127: Trick to make a color picker with VBA Read more »
Here I will show you how to make a simple color tester with VBA. This color tester is having only one big button. It will take input from the user for the value of Red, Green, and Blue. Then it …
Lesson#126: Making a simple color tester with VBA Read more »
Hello, we are back again with a very basic VBA learning topic. How to use a function with VBA. Here I am having an array with some random numeric values in the range A1:A10. I want to make SUM, AVERAGE, …
Another step towards learning VBA. In this post, we will learn to format text in excel with VBA. In the previous post, I discussed changing the cell background color and color codes. Lesson#123: How to change cell color with VBA …
Lesson#124: How to format text in excel with VBA Read more »
Here I will show how to change cell color by using VBA. These are the basic lessons for learning VBA. There are some methods to write code to change the cell background color. Here I have picked a cell range …
What is an Input Box? In VBA Input Box is a function that allows you to request information from the user who can type it in a text field of a dialog box. The basic syntax of this function is: …
What is a Message Box? A message box is a special dialog box used to display a piece of information to the user. The user cannot type anything in the message box. There are usually two kinds of message boxes …