- Microsoft visual basic for applications how to#
- Microsoft visual basic for applications code#
- Microsoft visual basic for applications series#
So you'd have to figure out a way to do it inside the different items that Microsoft has provided you.
But say you want to do something a little bit different? Well it's not there. But it's all within what they figured would be the steps or the procedures that people would want. And they will provide the means for some more experienced users to be able to do things. See when Microsoft creates these they look at well what would be the needs of the general or average user? And they'll create some procedures that can be activated by the click of an Icon Button up on the top of the screen. So why would you want to use it? Well as I said what VBA allows you to do is to customize your Microsoft Office product to do things that didn't automatically come with the product. So you don't have a lot of the shortcuts that you might have in other development environments. Well not exactly English sentences, you're writing statements in the language that will then be translated by the computer into computer speak, so the computer knows what it is that needs to be done. You got a blank window and you're typing sentences. Then you would customize and kind of tweak to look the way you want. Most of the applications have some nice little icons where you can click and have some base structures created on the web page. You know that in most programs that allow you to program in HTML and they're multiple applications out there that allow you to do that. HTML by the way is a language that is most frequently used in the world to create web pages. For instance if anybody has heard of HTML or done any programming in HTML. However VBA has a disadvantage versus some other programming languages in that the window, the environment in which you are writing VBA is very simple.
Microsoft visual basic for applications code#
You do not need to know the inner workings of the computer or how the computer will use the information you're providing it in order to be able to code in VBA. But VBA gives you a lot of latitude and it's really very simple. Certain reserved words in the language that the computer needs to recognize and that's similar to other programming languages.
Microsoft visual basic for applications series#
It does provide a series of structures which is the way things are organized and Keywords. VBA is a very, very simple programming language. Well you might have to know that for some programming languages but not for VBA.
Microsoft visual basic for applications how to#
They hear programming language and they think oh my god, I need to know a lot about how the computer works and how to talk to it and all the internal mechanisms of the computer. Now the minute I'd used that term, some people may cringe. Now VBA is a very simple programming language.
And that's really where the power of VBA comes in. Because those are the two products where people who have been using the product long enough and getting very advanced and experience have a tendency to want to create much more complicated items. Most Microsoft Office products have VBA Modules running though they are most commonly used with Excel and with Access. All the user would see is the result of that module running, whatever it causes to happen in the product. They don't see the Module Window itself come up. They do not get a little message that pops up on the screen that says you are now running a VBA Module. Now the average user does not know these are happening. It is a tool to create executable modules that would run in the background behind the various Microsoft Office products like Word, Excel, PowerPoint, Access, Outlook, et cetera. VBA stands for Visual Basic for Applications. In this lesson I will discuss what is VBA.
0 kommentar(er)
