Back to Top

Login | Register

Please Wait ..


Forum Home > Information Technology > Learning Excel VBA
 




Recent Topics


Post New Topic


30 January 2014, 02:10   Report Abuse

Vaibhav Joshi

(F)CA, MBA aspirant



[ Scorecard : 1413]


Sometimes though, despite the rich set of features in the standard Excel user interface (UI), you might want to find an easier way to perform a mundane, repetitive task, or to perform some task that the UI does not seem to address. Fortunately, Office applications like Excel have Visual Basic for Applications (VBA), a programming language that gives you the ability to extend those applications.

 

VBA works by running macros, step-by-step procedures written in Visual Basic. Learning to program might seem intimidating, but with some patience and some examples such as the ones in this article, many users find that learning even a small amount of VBA code makes their work easier and gives them the ability to do things in Office that they did not think were possible. Once you have learned some VBA, it becomes much easier to learn a whole lot more—so the possibilities here are limitless.

 

By far the most common reason to use VBA in Excel is to automate repetitive tasks. For example, suppose that you have a few dozen workbooks, each of which has a few dozen worksheets, and each of those needs to have some changes made to it. The changes could be as simple as applying new formatting to some fixed range of cells or as complex as looking at some statistical characteristics of the data on each sheet, choosing the best type of chart to display data with those characteristics, and then creating and formatting the chart accordingly.

 

Either way, you would probably rather not have to perform those tasks manually, at least not more than a few times. Instead, you could automate the tasks by using VBA to write explicit instructions for Excel to follow.

 

VBA is not just for repetitive tasks though. You can also use VBA to build new capabilities into Excel (for example, you could develop new algorithms to analyze your data, then use the charting capabilities in Excel to display the results), and to perform tasks that integrate Excel with other Office applications such as Microsoft Access 2010. In fact, of all the Office applications, Excel is the one most used as something that resembles a general development platform. In addition to all the obvious tasks that involve lists and accounting, developers use Excel in a range of tasks from data visualization to software prototyping.

 

Despite all of the good reasons to use VBA in Excel 2010, it is important to remember that the best solution to a problem might not involve VBA at all. Excel has a large range of features even without VBA, so even a power user is unlikely to be familiar with them all. Before you settle on a VBA solution, search the Help and online resources thoroughly to make sure that there is not a simpler way.

 

Attached herewith PDF for learning Excel VBA. If you have any query & need any assitance do post.

 



Attached File : 29_29_excel_vba_basics.pdf downloaded 474 times

Message thanked : 1 times



04 February 2014, 10:22  

shib

aa



[ Scorecard : 23]


Hi ,

I have created a multiple row Userform to add multiple values at once. Now i need to restrict the userform to add the data onto the excel sheet if any userform field remains blank and prevent duplicate entry which already exists. And after adding the data onto the excle sheet the data should get cleared after pressing the "Add Button" on userform.

Its a multiple line userform to add multiple entries at once.

The details are as follows:-

         Date     Party Name     INvoice No.      Net Amount     Tax     Gross

1.

2.

3

4

5

6

 

Thank you so much and will waiting for your reply

Regards

Shib

Message thanked : 1 times


04 February 2014, 18:27  

Vaibhav Joshi

(F)CA, MBA aspirant



[ Scorecard : 1413]


Hi

 

You can try this: http://www.contextures.com/xlUserForm01.html

 

Thx


14 July 2018, 17:54  

RafaelBauch





[ Scorecard : 24]


Excel is really hard to learn. I have taken the research papers help to know more about excel. It is really good to learn the excel which is used in many companies.





Related Topics / Similar Threads

More..

Post your reply for : Learning Excel VBA

Your are not logged in . Please login to post replies
Click here to login


Not a member yet ?? Click here to signup

Message




Subscribe to the latest topics :




Sign-in to your account


Username:
Password:

Remember Me

Forgot your password?

Sign-up now



Join MBAclubindia.com and Share your Knowledge. Registered members get a chance to interact at Forum, Ask Query, Comment etc.