Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can I learn VBA (visual basic application) in MS Excel? Can anybody suggest/guide me regarding this matter?

If you give some on line resource link to learn VBA, it will be a great help for me.

user-image
Question added by Ashis Basak FCMA , Senior Finance Manager , TotalEnergies Bangladesh
Date Posted: 2013/08/25
Nitin Gupta, ACA
by Nitin Gupta, ACA , FP&A , Rockwell Automation

Send me a mail at my email id ""

 

I will share some usefull information.

I learned VBA using a series of resources and techniques:   1.
I started to create my1st VBA scripts by "recording" the tasks I wanted the VBA script to perform.
Then I edit the recorded scripts, which is much easier as writing it all down.
  2.
I used the on-line VBA help in excel a lot, this gives a lot of good script examples.
  3.
On-line there are a lot of resources.
If you have a special task to perform, you can easily Google for the wanted complicated VBA script tasks, like error handling, opening/closing files, linking Excel with Word, etc.
  4.
If you still do not come out, you can ask forums (the forums you have perhaps already found under point3 by Google).

Atif Tanveer
by Atif Tanveer , Decision Support Specialist , Hamilton Health Science

Hi, Lot of learning material available on internet, give it a try.
http://www.excel-pratique.com/en/vba.php Post your problems at available fourms, you will get the solutions.
http://answers.microsoft.com/en-us   I learn that way.

SIGIT SUKRISNO
by SIGIT SUKRISNO , Technical Support Engineer , Rapyd

For beginner and basic understanding you can use this link: http://www.excel-vba.com/

Join VBA forum, this is a good link that I normally used: http://www.mrexcel.com/forum/forum.php

They will help you a lot as long as you ask them clearly about your problem. 

Have a nice code 

 

-sea-

Rochdi Aouadi
by Rochdi Aouadi , Senior software Quality and Test Engineer , Capgemini Engineering

HI,

I can help you if you need.

Aslam Khan
by Aslam Khan , Senior Accounts Officer , Pakistan Software Export Board

vba plays a significant role in automation of financial and other reports. It is being widely used in Microsoft Excel, Word, PP and Access 

you can visit  my below given small blog for vba for excel for begineers might be helpful for you

nasirabadi.blogspot.com

Usman Masood
by Usman Masood , Chief Financial Officer , Siddiqi Group

Dear Ashis

 

Some useful links for your ready reference.

 

http://msdn.microsoft.com/en-us/library/gg597509(v=office.14).aspx 

 

http://en.wikipedia.org/wiki/Microsoft_Excel 

 

Thanks

Usman

Tomasz L
by Tomasz L , Reporting Specialist , Outworking

Start wth "Excel VBA Programming For Dummies". You will find there the basic elements of VBA language. 

 

Firas Shahadi
by Firas Shahadi , Training And Development Director , Muhayal Assir National Hospital

you can start with Microsoft here. And great help source is the help provide by Microsoft in MS Excel or Access

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.