Differences
This shows you the differences between two versions of the page.
Previous revision | |||
— | dev:visual_basic_for_applications [2023/05/01 17:32] (current) – [Hello World] Henrik Yllemo | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <button type=" | ||
+ | ====== Visual Basic for Applications ====== | ||
+ | <data programminglanguage> | ||
+ | Full Name: Visual Basic for Applications | ||
+ | Short Name: VBA | ||
+ | Description: | ||
+ | Company: Microsoft | ||
+ | Web: No | ||
+ | Mobile: No | ||
+ | Enterprise: Yes | ||
+ | Embedded : No | ||
+ | </ | ||
+ | < | ||
+ | <panel title=' | ||
+ | VBA is a programming language that is integrated into Microsoft Office applications, | ||
+ | </ | ||
+ | With VBA, you can automate repetitive tasks in Microsoft Office applications, | ||
+ | </ | ||
+ | Yes, VBA is still relevant for those who work with Microsoft Office applications. Many businesses and organizations use VBA to automate repetitive tasks and build custom applications that integrate with their existing systems. While newer languages and frameworks may offer more advanced features, VBA remains a valuable skill for those who work with Microsoft Office on a regular basis. | ||
+ | </ | ||
+ | Yes, VBA is designed to be easy to learn, even for those without any programming experience. The language uses a syntax that is similar to other programming languages, but is more forgiving and provides helpful suggestions and auto-complete features. | ||
+ | </ | ||
+ | There are many resources available to learn VBA, including online tutorials, books, and video courses. Microsoft also provides documentation and sample code on their website, as well as an active community of VBA developers who share tips and best practices. | ||
+ | </ | ||
+ | |||
+ | |||
+ | {{wp> | ||
+ | < | ||
+ | ===== Hello World ===== | ||
+ | |||
+ | <sxh > | ||
+ | Public Sub Main() | ||
+ | MsgBox " | ||
+ | End Sub | ||
+ | </ | ||
+ | <WRAP column right>< | ||
+ | </ | ||
+ | |||
+ | |||
+ | === ## ToDo ## === | ||
+ | * FIXME | ||
+ | * Macros | ||
+ | * Procedures | ||
+ | * Functions | ||
+ | * Variables | ||
+ | * Control structures | ||
+ | * Object-oriented programming (OOP) | ||
+ | * Classes | ||
+ | * Inheritance | ||
+ | * Polymorphism | ||
+ | * Events | ||
+ | * Forms | ||
+ | * User interfaces | ||
+ | * Controls | ||
+ | * ActiveX controls | ||
+ | * Input/ | ||
+ | * File handling | ||
+ | * Error handling | ||
+ | * Debugging | ||
+ | * Add-ins | ||
+ | * Automation | ||
+ | * Excel VBA | ||
+ | * Access VBA | ||
+ | * Word VBA | ||
+ | * Outlook VBA | ||
+ | * PowerPoint VBA | ||
+ | * Automation Add-ins | ||
+ | * COM (Component Object Model) | ||
+ | |||
+ | |||
+ | |||
+ | See also: [[dev: | ||
+ | |||
+ | {{tag> |