VBA - What is and you have to learn?

Image : http://www.flickr.com

Intermediate or advanced user of Office may be wondering "what next?" after they learn many of the more complex instruments in many applications. Visual Basic is something that many people have heard of, but I'm not sure exactly what it is, or is of interest to them. VBA is a programming language, so if you're just looking to gain further knowledge of Office without tweaking directly with your own macros or add applications, you may not be foryou.

VBA is, understandably, a derivative of Visual Basic, which can be coded independently, and VBA can be used inside a host's "demand" (ie the majority of MS Office packages, especially Word and Excel). More advanced users will recognize the use of VBA in existing applications such as Microsoft Visio, Visual Basic and is used in some non-Microsoft products such as AutoCAD and WordPerfect. Some Office programs have their simple programminglanguages, for example, WordBasic for MS Word. However, you can do much more with VBA: works very well within the standard Office applications.

Think of each Office application as a template that you can alter, and you can begin to understand how to use VBA. The applications are divided into objects - for example, the menu bar in Excel is an object, as is the element header and footer in Word. Each object has properties that can change from a level of small (by a phrase in italics)a high level: the modification of the menu bar selections to suit themselves. All VBA is, in essence, is allow you to change the properties of these objects, even where existing functions not shortcut the way you need. For example, if you frequently use the Verdana font to 36 point bold text, because the company "look" you use in your stationary, you can program a keyboard shortcut to immediately give the object (text) properties (bold, size, etc.) that you want - without having to gothrough the various menu items individually.

Here's another example of how you can use VBA. Excel has a function "workday", which returns every weekday as a number (1 for Sunday, Monday or if you prefer, 2 for Tuesday and so on). However, it could be more helpful (especially when you share the workbook) to get the names of the days indicated, in other cases they do not understand the references to days. There is no function to do this, then you need a user-defined, or UDF, whichyou can program in VBA. It is not immediately obvious how you could use VBA, but in reality, all the Office programs are already built in. VBA Editor

If you would think that someone, somewhere has already thought of an answer to the problem that you VBA (and need some code) - you'd be right! There are literally thousands of sites with pieces of code, user-defined functions, macros, and other bits and pieces useful to get you going with VBA. If you get more experience,could be considered to add too, if you think you've found the office last tweak to make it work better. If it is useful and effective, go ahead and share!

csharp and media player pc game