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

Exercise 24: Monthname Function

To create this Function, execute the following steps

1. Create a UDF Monthname() ( User Defined Function)

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 Monthname() In Cell B1  Type

=Monthname(A1)

2. Use Excel Formulas (CHOOSE)

Syntax

CHOOSE(index_num, value1, [value2], ...)

=CHOOSE(A1,C2,C3,C4,C5,C6,C7,C8,C9,C10,C11,C12,C13)