VBA works within a host environment such as Microsoft Office or SAGE Accpac. They also both have a module window to show you the code that you are creating. They both have a properties window to show you the properties of the objects you are working with. Once again, other windows are available from the Window menu.Īs you can see from the two pictures above, the two environments share a lot of features – they both have an explorer window to show you what objects (forms and modules) are stored in the project you are working in.
If you open visual Studio and create a new VB.Net Project, you will see that the screen is made up of the module window, the solution explorer, and the properties window. Visual Basic is written within Visual Studio. There are other windows available, which you can access by clicking on the Window menu. The screen is made up of a module window, a project explorer, a properties window and an immediate window.
To access the VBE, you can press Alt F11 on your keyboard from within Word, Excel, PowerPoint or Outlook, for example. VBA is written in an editor called the VBE – the Visual Basic Editor.
0 kommentar(er)
