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 …
Excel doesn’t accept formatting cells that are protected if they aren’t allowed for users. To format unprotected or protected cells users must allow them before protecting a sheet. When you are protecting a sheet just see these options. The third …
Lesson#122: Cell formatting in a protected sheet in Excel Read more »
OK, I am having a sheet here which calculates the age when the birth date is provided. I need to protect the sheet before giving it to users. So none of them change the structure or formula. But I also …
Lesson#121: How to make some cells unprotected when protecting a sheet Read more »
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: …
