VBA programming in MS EXCEL

Chemical engineering, Plant designs related to chemical, petro-chemical or oil&gas, Operational assistance, etc.
Post Reply
Black Onyx
Posts: 16
Joined: 25 Mar 2010, 03:33
Area of interest: Chemical Engineering

VBA programming in MS EXCEL

Post by Black Onyx »

Can anybody provide me tutorials for VBA programming in EXCEL.

Regards,
Imran.Idris
Core Member
Posts: 59
Joined: 16 Mar 2010, 04:22
Area of interest: Chemical Engineering

Re: VBA programming in MS EXCEL

Post by Imran.Idris »

Go through the attachment. I hope you'll get what you wanted......
You do not have the required permissions to view the files attached to this post.
tosif
Core Member
Posts: 62
Joined: 15 Mar 2010, 23:46

Re: VBA programming in MS EXCEL

Post by tosif »

Macro(s) in excel can be created by two methods. First one and the easiest one is to record a macro for automation of any particular action. For example; goal seek actions, cells addition, deletion, format actions can easily be automated using this simple macro record function. Further fine tuning can obviously be done using knowledge of VBA.
Second method is creating or writing coding from scratch. It will give more space for the designer to integrate other softwares also, such as hysys, visio and other VBA supported softwares. To work in VBA editor, I will personally recommend you to install MSDN library. It will provide a very comprehensive help regarding coding in VB and other associated languages. Yeap, of-course prior to get into leaning syntax of any language, you have to understand or learn the work-flow or action-flow of the program.
Black Onyx
Posts: 16
Joined: 25 Mar 2010, 03:33
Area of interest: Chemical Engineering

Re: VBA programming in MS EXCEL

Post by Black Onyx »

Thanks a lot for the useful tips, but where i can find the MSDN library ?

regards,
ibrahim
Posts: 80
Joined: 19 Apr 2010, 14:25
Area of interest: Chemical Engineering

Re: VBA programming in MS EXCEL

Post by ibrahim »

MSDN library is a documentation based real-time-help-software by Microsoft. For visual studio 6, Microsoft is no longer providing MSDN library. and as this is not a free-ware, its hard to find it over shops. Try googling it over internet.
Post Reply