PetroStreet

Can anybody provide me tutorials for VBA programming in EXCEL.

Regards,

Go through the attachment. I hope you'll get what you wanted......

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.

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

regards,

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.