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

Exercise 20: View the Formula of cell in another Cell

1. Create a UDF Formuladisplay (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:

Insert the below code in a New Module

This Code lines will create function Formuladisplay () , In Cell D1 Type

= Hedqtrs( (C1)

Syntax FORMULATEXT(reference)

2. Use Excel Formulas (FORMULATEXT)

=FORMULATEXT(C1)