Learn Excel - Macro writting

Hi Guys

I am back

wanna learn excel macro writting

do it like this

open visual basic editor   " Tools ---> Macro -----> Visual basic editor"

now what ever comes to your mind related to function or else type it in help window read it and exand upto u can understand there will be lots of examples,

another very good way is copy examples code in modules and run the macro u will get more clarity and understanding of coding as well as working of macro & excel

 

Sandeep K.

Replies (12)

because i am in accounts, so i need to learn about excel mecro

Hi,

Do you have the notes to learn Macros.. if could you send any basic macros like adding numbers, subtact, Mulitiplication and division and other test related macors.

 

 

VBA help (i.e. F1 key) itself is the note book & very good collection of notes on macro

What is the use of macro in Excel.Pl reply.

Hi Ashok,

Macro is like a ghost in Excel, which automatically does all the manual work which you are supposed to do....

Macro is a very AMAZING TOOL .....for eg:- If a process takes you 1 hr or more in excel, you can automate it with help of macros.  Macros will reduce to processing time from 1hr. to seconds (or milliseconds)....so perfect it is....

Almost everything what you do manually in excel can be done in macro...

Macro is not only limited to excel, it is also applicable to word, ppt and other office applications.  Even your desktop can be operated with Macro.  Desktop macros will record Keyboard or Mouse movements and repeat the same.  For eg:- i used to open my lotus notes in office by just pressing a shortcut key which will trigger a desktop macro.  That macro will go to start, programs, lotus notes, type my password and open my inbox and refresh it....(all within seconds)....

Excel Macros work only when excel is open.  Hence to open excel and make the macro run, we had to use Desktop macro. 

Simply MACRO is amazing feeling....it is wonderful to see excel working automatically...as you do........you can experience it by using it......start learning from today....

Regards,

gurusanthanam

Dear all,

I am vey excited to see this useful information.

Plz explain desktop macros and method to create one.

Regards:

Vinod

Originally posted by :Vinod
" Dear all,
I am vey excited to see this useful information.
Plz explain desktop macros and method to create one.
Regards:
Vinod
"

Originally posted by :guru santhanam
" Hi Ashok,
Macro is like a ghost in Excel, which automatically does all the manual work which you are supposed to do....
Macro is a very AMAZING TOOL .....for eg:- If a process takes you 1 hr or more in excel, you can automate it with help of macros.  Macros will reduce to processing time from 1hr. to seconds (or milliseconds)....so perfect it is....
Almost everything what you do manually in excel can be done in macro...
Macro is not only limited to excel, it is also applicable to word, ppt and other office applications.  Even your desktop can be operated with Macro.  Desktop macros will record Keyboard or Mouse movements and repeat the same.  For eg:- i used to open my lotus notes in office by just pressing a shortcut key which will trigger a desktop macro.  That macro will go to start, programs, lotus notes, type my password and open my inbox and refresh it....(all within seconds)....
Excel Macros work only when excel is open.  Hence to open excel and make the macro run, we had to use Desktop macro. 
Simply MACRO is amazing feeling....it is wonderful to see excel working automatically...as you do........you can experience it by using it......start learning from today....
Regards,
gurusanthanam
"


 

Originally posted by :guru santhanam
" Hi Ashok,
Macro is like a ghost in Excel, which automatically does all the manual work which you are supposed to do....
Macro is a very AMAZING TOOL .....for eg:- If a process takes you 1 hr or more in excel, you can automate it with help of macros.  Macros will reduce to processing time from 1hr. to seconds (or milliseconds)....so perfect it is....
Almost everything what you do manually in excel can be done in macro...
Macro is not only limited to excel, it is also applicable to word, ppt and other office applications.  Even your desktop can be operated with Macro.  Desktop macros will record Keyboard or Mouse movements and repeat the same.  For eg:- i used to open my lotus notes in office by just pressing a shortcut key which will trigger a desktop macro.  That macro will go to start, programs, lotus notes, type my password and open my inbox and refresh it....(all within seconds)....
Excel Macros work only when excel is open.  Hence to open excel and make the macro run, we had to use Desktop macro. 
Simply MACRO is amazing feeling....it is wonderful to see excel working automatically...as you do........you can experience it by using it......start learning from today....
Regards,
gurusanthanam
"


 

Hi

Can you explain us in detail....

hi respected seniours

 

I want to learn the MACRO & VISUAL BASIC IN EXCEL ..IT THERE IS ANY DICTIONERY , NOTES OR SITE Which helps me to learn above said...

 

Please help me friend.. i m very curios to learn this..

thanksss.

deepak..... deepak_8583 @ yahoo.com

 how to learn macro (vba coding)?

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details