How to view, create and record and edit and Delete macros in Excel VBA

To view Macro

>Open excel

>Click on Developer

> Click on Macros

> Select the macro and click on run 

Record Macro

 > Open Excel

> Click on 'Record Macro'

> Enter the name of the macro

> And click on OK

> Now enter the values in row or do any thing (create button)

> Now click on stop recording

> Now click on macros and you can run the macro 

 

Create new macro with VB

>Open excel

>Click on Developer

>Click on Visual basic

>Under 'Microsoft excel objects' 

>Click on Sheet 1

> Write the below code

Sub test()
    ActiveCell.FormulaR1C1 = "12"
    Range("A2").Select
    ActiveCell.FormulaR1C1 = "34"
    Range("A3").Select
End Sub

> And now click on Macros and click on Run

Edit Macro

>Open excel

> Click on Developer

>Click on Macros (test 1)and Click on Run 

Delete Macro

>Open excel

> Click on Developer

>Click on Macros (test 1)and Click on Delete