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 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 [...]

GTIN Calculator in Excel

GTIN Calculation is basically of different types like GTIN 8, GTIN 12, GTIN 13 and GTIN 14. We can calculate GTIN by using Excel Formula as well as Excel Macro. GTIN Calculator By Formula | GTIN Calculator By Macro | How to Calculate GTIN | Download GTIN Calculator GTIN Calculation- By Excel Formula: GTIN-8 "000000"&F11 & (IF(MOD(3*(MID(F11,1,1) + MID(F11,3,1) + [...]

By |Categories: Excel Macro, Popular Articles|Tags: |9 Comments

Oracle Connection String in VBA

Dear Friends, Using Excel Macros (VBA) you can connect to Databases like SQL, Oracle or Access DB. In this Article, I will teach you, how you can do a connection with a Oracle Server. We can do connection with Oracle either by giving SID (Oracle System ID) or Service Name. Whichever is available for the connection, we can use them [...]

How to restrict some key or Characters in text box in a Excel Macro

When you are using Text Boxes in Excel Macros then there are some instances where you want to restrict some entries in the Text Box. For example: A Textbox where you are entering Amount. Here you may need that you should be able to Enter All numeric characters from 0-9 and also Decimal (.) and Minus Sign(-). You don’t have any inbuilt functionality in Excel Textbox to restrict it to only Numeric Value. However by writing a piece of Code under KeyPress Event of Textbox, you can achieve this. Just copy paste the below mentioned code under KeyPress Event of the Text Box. […]

Page 5 of 512345