Excel VBA formulas for Spreadsheet by Sharath Kumar Peechara - HTML preview

Exercise 21: Function with Case Insensitive

1. Create a UDF Hedqtrs( User Defined Function)

To create this Function, execute the following steps

1. Open Excel VBA (Alt + F11)
2. Insert a New Module
3. In the Project Explorer, double click on the Module
4. Add the following code line:

This Code lines will create function Hedqtrs() , In Cell B1 Type

= Hedqtrs( (A1)

2. Use Excel Formulas (IF,PROPER)

Syntax

IF(logical_test, value_if_true, [value_if_false])

PROPER(text)

Use (IF,PROPER) function together, In Cell B1 Type

=IF(PROPER(A1)="City","NEWYORK"," ")