120+ Professional Project Management Templates!
Save Up to 85% LIMITED TIME OFFER
Project Management Templates

Excel VBA

Excel VBA is the macro programming language available in the Excel and other MS office tools. It helps to automate the regular tasks, create the dashboards and build the tools to perform certain tasks.

Folders and File Handling in Excel VBA

2023-03-18T14:16:34+00:00

Folder and File Handling in Excel VBA Examples help you to create, delete,copy,move files and folder. And customize File or Folder dialog Box using VBA.

Folders and File Handling in Excel VBA2023-03-18T14:16:34+00:00

Interacting with Other Applications using VBA

2022-06-17T03:55:49+00:00


We can interact with the other applications using VBA - with the MS Office Applications like Word, PowerPoint,Outlook,etc... and other applications like Internet Explorer, SAS,etc.

In this Section:
  • Introduction?
  • How to interact with MS Word? - Late Binding
  • How to interact with MS Word? - Early Binding
  • How to interact with PowerPoint? - Early Binding
  • How to interact with Outlook? - Late Binding
  • Example File
Interacting with Other Applications using VBA2022-06-17T03:55:49+00:00

VBA Security in Excel

2022-06-17T03:55:46+00:00

It is important to understand the macro security if you are dealing with the Macro Enabled Files. It helps to protect your data from the malicious programs and helps to know how to run the macros when its required.

In this Section:
  • Understanding VBA Security
  • What are the different Levels of the Security in VBA?
  • How to Enable or Disable the Macros?
  • How To Protect VBA Code?
VBA Security in Excel2022-06-17T03:55:46+00:00

VBA Objects Properties and Methods in Excel

2022-06-17T03:55:46+00:00

Most of the programming languages today are Object Based Or Object Oriented Programming Languages. Although Excel VBA is not a truly object oriented programming language, it does deal with objects.

In this topic:
  • What are Objects?
  • What are Properties?
  • What are Methods?
  • What is Object Browser?
VBA Objects Properties and Methods in Excel2022-06-17T03:55:46+00:00

Forms and Controls in Excel VBA

2022-06-17T03:55:41+00:00

Any Windows Application is equipped with set of objects called windows controls. The Main control is called a Form, it is the primary window contains different types of controls which allow user to interact with the computer. The following is a simple form to calculate square value of a given number.

In This Section:
  • What Are UserForms?
  • What Are ActiveX Controls?
  • What Are The Different UserForm Controls & Use?
  • Practical Learning: Developing A Simple UserForm
  • Example File
Forms and Controls in Excel VBA2022-06-17T03:55:41+00:00
Go to Top