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 …
Here I will show you a funny trick to make a dancing chart in excel. For that, you have to follow some steps. 1. Make a range of data names like A, B, C, and D….. 2. Then put values …
Lesson#109: Tricks to make a dancing chart in excel Read more »
In this post we shall take a VBA lesson which is how to insert rows in worksheet using VBA. So for this you have to open an excel worksheet and press Alt+F11 to go to VBA editor. For inserting a …