If you want to extract email ID from a String Stored in any cell, it is possible by writing a Simple UDF (User Defined Function) in Excel. After writing this UDF, you can use this function as a normal Excel Function. Follow the below Steps: 1. Open Visual Basic Editor...
Results for "excel"
Auto Open Macro / Auto Run Macro
Sometimes in Excel Macro, you need to execute a Macro / Piece of code as soon as you open the Workbook. By Doing this no need to trigger that Macro or functions just by opening that workbook. There are two methods to achieve this. Method 1: Auto Run Macro in VBA...
How to force proper case in textbox
Proper Text is nothing but each word will have it's first letter in caps. If you want to change every first letter of each word in a sentence then you can use StrConv function of VB in VBA. Syntax: String(Mandatory) String is the String which you want to make in...
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...
How can I force input to Uppercase or Lowercase in a Textbox
At some point of time you may need user to force to Enter in a particular Case in your Excel Macro Text Box. It could be either in a Lower Case or Upper Case. Unfortunately in VBA Text Box, you don't have any inbuilt settings to do so. However by writing few lines...
File Name Formula
There are few instances when we want to store the File Name or Current Workbook Name in a particular Cell. This is very easy. This can be done by using Cell() function as shown below: Syntax: =CELL("filename") Returned Value: C:\Users\Vish\Desktop\[Test.xlsx]Sheet1...
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...
How to Edit Existing Conditional Formatting
For editing Conditional Formatting of an Excel Workbook, follow following steps. It is different for Excel 2003 and 2007. So we will see the steps for both Excel 2003 and 2007. Excel 2007 || Excel 2003 Excel 2007: a) When you know the cell or cell range where that...
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...
Restrict to fixed text or integer length in the given range of cells
Follow below steps to Restrict to fixed text or integer length in the given range of cells: 1. Select the Cell Range where you want to put the restriction 2. Go to "Data" Tab in Excel 3. Click on Data Validation Option and Select "Text Length" from the Drop...
Buy a coffee for the author
Download FREE Tools and Templates
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.