How to write Macro coding? How to run macro coding ? How to see macro coding? How to Enable Developer Mode?

How to open VBA and run macro program in Excel

How to See Macro Coding?

Open New excel File …. And Press ALT + F11 it will redirect you to the coding window.

Else open Excel and find Developer mode and press Visual Basic.

Step: 1

How to enable Developer mode on excel?

OMG… if you can’t able to find Developer mode then go to File - > Options on your Excel And find Customize Ribbon and check Developer. Now do the above process to view the coding window.

Again Step 1:

Step 2:

How to Write Macro Coding? How to Run Macro Coding?

Click “ThisWorkbook” on project window (Left side )

And write your coding like below one (Don’t copy paste just 3 line you can type) ,Now press F5 to run macro coding.

Coding:

Sub Test()

Msgbox “Hello World”

End sub