Popular Articles

This is the category all the popular articles are categorized. Interested in reading all the popular reads.. this this the place

How to Send an Email using Excel Macro from Gmail or Yahoo

Dear Readers, In this article we are going to learn how to send an email automatically by Excel Excel VBA. While executing the Excel Macro some times you may need to send some Details or Result directly to your email ID or any other ID using Excel Macro. If you have some report or details which you want to send [...]

ADO RecordCount Property – RecordSet Object

The RecordCount property returns a long value that indicates the number of records in a Recordset object. Many a times you might have observed that RecordCount Property does not return a correct number instead it always returns a number -1. RecordCount Property returns -1 because by default the Cursor is adOpenForwardOnly. To get the exact Record Count from your RecordSet [...]

Textbox first Letter in Caps and Rest other in Lowercase

If you want to automatically make first letter in Uppercase and rest of the characters in lowercase. No matter what case you are typing-in but it will be automatically done by Copying and Pasting the below Code under KeyPress Event of the Textbox Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Select Case KeyAscii Case Asc("A") To Asc("Z") If InStr(1, TextBox1.Text, Chr(KeyAscii)) [...]

SQL Connection using Excel Macros

Dear Friends, Using Excel Macros (VBA) you can connect to Databases like SQL, Oracle or Access DB. In this Article, I am going to teach you, how you can do a connection with a SQL Server. SQL databases has mainly two type of authentication : 1. Windows Authentication 2. SQL Server authentication. Here in this article, I will share VBA [...]

How to Create Drop Down List in Excel

Drop down list is made in Excel Cell to limit the Entry in to a Cell from a predefined set of values. It means you are restricted to select one value out of set of Predefined values. On creating a drop down list on a cell or cell-range, one drop-down will be displayed with set of predefined values, on selecting [...]

Conditional Formatting based on Condition in other Cell

In previous post we saw the normal conditional Formatting. It means based on the condition of a cell, changing the format of same cell is normal conditional formatting. But here we are going to see the conditional formatting of a cell based on some other cell condition. Suppose if you want to change the formatting of a cell based on [...]

Conditional Formatting in Excel

Conditional Formatting in Excel: In MS Excel we can do formatting of cells based on some conditions or values. This is called Conditional formatting. For example, if you want a cell color to be red whenever the Value in the Cell is updated as “FAILED” or “Less Than 60%” etc. then we can apply conditional formatting in that cell. Conditional formatting can be done on a single cell or a range of cells or […]

VBA: Reverse a string

It is very easy to get the Reverse of a string entered by user in Excel VBA by using VBA inbuilt functionality. strReverse() is the inbuilt function which returns reverse of the String given as input to this function. Syntax: strReverse("Your Input String") Returned Value: It returns a reversed string of your given input String. Example:Below code will return the [...]

Sorting a String stored in a cell of Excel

Dear Readers, By using Excel Macro, we can sort a String which is stored in a Cell in an Excel Sheet. Sorting will be done as a String. For example (Ascending): First all Numeric Values in ascending Order then Special Chars then Alphabets in ascending etc. Sorting For this we need to copy and Paste below Sub Function [...]

List All files from Folder and Sub-folders in Excel Workbook

By using File System Object, we can get list of all Files inside a folder. There can be two types of requirements here. Either user wants all files in only one Folder or list of all files in All folders and its sub-folders. Following is the solution for both the requirement: User wants to get the list of All files [...]

Page 5 of 6« First...23456