Can anybody provide me tutorials for VBA programming in EXCEL.
Regards,
VBA programming in MS EXCEL
-
Black Onyx
- Posts: 16
- Joined: 25 Mar 2010, 03:33
- Area of interest: Chemical Engineering
-
Imran.Idris
- Core Member
- Posts: 59
- Joined: 16 Mar 2010, 04:22
- Area of interest: Chemical Engineering
Re: VBA programming in MS EXCEL
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.
Re: VBA programming in MS EXCEL
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.
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.
[ t o s i f ]
http://tauseef.engoneer.com
http://tauseef.engoneer.com
-
Black Onyx
- Posts: 16
- Joined: 25 Mar 2010, 03:33
- Area of interest: Chemical Engineering
Re: VBA programming in MS EXCEL
Thanks a lot for the useful tips, but where i can find the MSDN library ?
regards,
regards,
Re: VBA programming in MS EXCEL
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.