Simple way To Start learning Macros

Dear Friends,


Better way to understand macros is to RECORD and then "Read" the VB Script generated by the Macro to understand it.


Click Tools > Macros > Record New Macro


It will ask for macro name....(give some macro name)

Remember to select "This workbook" option in that window.


Once you click OK, a Macro "Stop Recording Toolbar"  will appear......


Try to do some simple calculations in the blank excel sheet.....(keep it very simple so that you can remember later)


Click Stop recording in "Stop Recording Toolbar"


Press Alt+F11 and in Top Left Hand side Corner...you can find the workbook on which you created will be listed.  In that list, select your workbook and open Modules Submenu listed in the same place....


Open Module 1.....you can see the macro name which you specified and the recorded VB Script for the activities which you did in the worksheet....


Try to recollect what you did in the worksheet and try to understand how to excel has interpreted it and recorded the VB Script...


This is the beginning to learn Macro....


Sample simple scripttts for your understanding:-


Range("D22").Select                   (means YOU have clicked D22 Cell in the worksheet.)

Sheets("Sheet3").Select               ( means YOU have clicked worksheet with name Sheet3)

Range("B4:I15").Select                  (means YOU have selected the range B4 to I15 )


Remember by doing this you can just have a look at a drop of an OCEAN......


Have faith, Try to do more, Explore....you ll be the master.....


Hope this helps u all


Regards,

gurusanthanam


Thanks to :Nagaraju pogula CA


------

"The difference between genius and stupidity is that genius has its limits." - Albert Einstein


"When I can't handle events, I let them handle themselves. " - Henry Ford

 

Replies (4)

Thank U Guru.

plz tell me

How I use these Macros? I mean what are the benefits of these Macros?

Very Nice

Thanks

Balaji,

Pls read my post in this thread...it would be helpful...

/forum/messages/2008/6/9941_learn_excel_macro_writting.asp

Regards,

gurusanthanam

 

Learn how to write code in VISUAL BASIC.

Its quite easy.

Try "Higher Secondary Text Book for twelth standard on Visual Basic"

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details