How to Insert Formula by using the Macro in Microsoft Excel

[Nisha Dhawan]

In this article we will learn how to insert the formula in VBA and what is the use of it to write the VBA code.
When you having problem with inserting formula into cells in VBA. How we should explain the syntax in VBA coding.
For Example: - I want to insert the formula in Cell C2, =B2-A2. Follow below given steps to write the code in VBE.
• Open Excel file and then Press the key Alt+F11 on the keyboard.
• VBE page will get open.
• Write the below mentioned code:-

Please Login or Register  to view this content.

• To run the Macro press the key F5 on your keyboard.
• Formula will calculate by subtracting the numbers.

By using this way we can easily define the syntax and use of it while writing the VBA code.

[Kaper]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon (Icon! Not write hash character) at the top of your post window. More information about these and other tags can be found here

Moderator comment: This thread should not receive responses until OP complies with request for code tags

[TMS]

Interesting that the Code Tags were added by EFManagement.

[Kaper]

Just a comment: Don't get fooled by a title. The code will NOT insert the formula in a cell. It will insert the result of formula.