If you've been using computers for a reasonable amount of time, you're probably quite familiar with menu bars.If that's the case, the VBE menu bar is not very different from the other menu bars you've seen before.This is the only toolbar that the Visual Basic Editor displays by default.
You're probably aware that a toolbar contains on-screen buttons, icons, menus and other similar elements that you can use while working with the VBE.
The toolbar that appears in the screenshot above is called the Standard toolbar.
Formula R1C1 = '=Find('','', R2C1, 1)' kod = Cells(1, 9) : kod=...
For some people, the answer will revolve around having to learn a new programming language and coding.
You can open the VBE using either of the following methods: The basic VBE window can be divided in the following 6 sections, all of which I explain below.
In reality, there are more components than those which appear in this screenshot (such as the Locals and Watch Windows) but, since they're more advanced, I'll cover them in a future Excel tutorial.
However, sometimes I take a look around the Internet to see if I can find a good and comprehensive Excel tutorial about the VBE.
The truth is that, as of the time of this writing, there are not that many online resources covering this in detail. After all, I'm sure about one thing: Many people who are interested in learning macros and Visual Basic for Applications feel confused the first time they open the Visual Basic Editor.
In fact, in order for the VBE to be able to run, Excel must be open.