Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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 ajoutée par Ashis Basak FCMA , Senior Finance Manager , TotalEnergies Bangladesh
Date de publication: 2013/08/25
Nitin Gupta, ACA
par 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
par 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
par 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
par Rochdi Aouadi , Senior software Quality and Test Engineer , Capgemini Engineering

HI,

I can help you if you need.

Aslam Khan
par 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
par 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
par Tomasz L , Reporting Specialist , Outworking

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

 

Firas Shahadi
par 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

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?