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

Exercise 13: Excel RT Version Function

1. Create a UDF (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 Will Create A new UDF (User Defined Function) with name xlVers(),we Can use this As we Required. type in Excel the function = xlVers(),the UDF Comes up in small letter’s to differentiate itself from Standard Excel Formula

In Cell A1 Type

= xlVers()

It will show result As 16