0
Still curious? Ask our experts.
Chat with our AI personalities
Ezra
Rafa
DevinAdd your answer:
Earn +20 pts
What are the pros and cons of using Visual Basic on Excel?
Excel has a variation of Visual BASIC built into it, called Visual BASIC for Applications, commonly called VBA. The advantage of using VBA is that it greatly enhances what you can do with Excel. It gives you greater power to do things with Excel that are difficult or impossible with Excel formulas. It can help automate tasks by creating simple macros. It brings the powers of programming to Excel.The main disadvantage is the complexity of VBA if you are not familiar with it. It takes time to learn how to use it, and even then it can be complicated to get it to do what you want. If you have knowledge of Visual BASIC that will help, but there are aspects of VBA that are especially for working with Excel. There is the danger to ruining your data if you do something wrong with VBA.
Vba code to create a sales order in pastel evolution SDK?
Contact me via email akwasi2 at gmail dot com
When engineering controls are not adequate what forms of controls can be implemented?
physical and administrative
When engineering controls are adequate what other forms of controls can be implemented?
physical and administrative
What does it mean that VBA is objcet and event driven programming language?
Object driven programming languages are all based around objects on a 'form' or a 'room'. For example the program will be ran around buttons or other controls. For example if a user clicks a button a set of defined steps will occur. Event driven is similar. For example if this occurs then do this. For example while counter = 1 do .... Basically it is more simple for novice programmers to use and get their head around.
