Lesson#124: How to format text in excel with VBA

Another step towards learning VBA. In this post we will learn to format text in excel with VBA. In the previous post I discussed about changing cell background color and about color codes. So we will start in a little advance mode here. I am here taken an example of cell A1. I am going…

Lesson#123: How to change cell color with VBA

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 a code to change cell background color. Here I have picked a cell range A1:A10 as an example. Now press Alt+F11 to go to VBA editor and click on…

Lesson#120: What is Input Box in VBA?

What is 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: InputBox(prompt[, title] [, default] [, xpos] [, ypos] [, helpfile, context]) As String First example showing…

Lesson#119: What is Message Box in VBA?

What is 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 you will create: one that simply displays information and one that expects the user to make…

Lesson#109: Tricks to make a dancing chart in excel

 Here I will show you 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, D….. 2. Then put values against these names with RANDBETWEEN formula by putting any arbitrary lower and upper values.   3. Then…

Lesson#91: Insert rows in worksheet using VBA

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 row at a particular range say A5  you have to write a simple code. Sub…

Lesson#81: Making an automatic analog clock in excel with pie chart

Previously I had discussed about how to make an analog clock with piechart in excel. I am sharing the post link below. Lesson#61: Making a semi analog clock with pie chart Now I will add some simple VBA to make the clock auto refreshed every second. So I have taken these simple steps. 1. From…

Lesson#80: Make an automatically refreshing bar clock in Excel

We will learn how to make an automatically refreshing bar clock in excel. 1. First I made a three merged cells by putting these formulas =HOUR(NOW()) =MINUTE(NOW()) =SECOND(NOW()) 2. Select those cells one by one and clicked on Conditional Formatting>Data Bars>Solid Fills I did put the min value 0 and max value 23 for hours…

Lesson#79: Automatic changing Excel sheet color in every second

Let me show you how to make a spreadsheet which changes its color in every second automatically. to make this you have to follow some steps where I will apply a little VBA to make it really automatic. 1. Click the upper left corner of sheet to select all of the spreadsheet. 2. Go to…

Copyright 2017-2018@Excelabcd