Current location - Health Preservation Learning Network - Healthy weight loss - What's the difference between VBA and VB in EXCEL?
What's the difference between VBA and VB in EXCEL?
The differences between VBA and VB in EXCEL are: different nature, different operation dependence and different independence.

First, the nature is different.

1, VBA:VBA is a subset of VB, which automates existing applications (EXCEL).

2.VB: VB is an application program aimed at creating an application program (EXCEL) standard.

Second, operational dependence is different.

1, VBA: A program developed by VBA must depend on its parent application.

2.VB: To run the application developed by VB, users do not need to install VB, because the application developed by VB is an executable file.

Third, independence is different.

1, VBA:VBA has poor independence and must be parasitic on existing applications.

2.VB: VB is independent and has its own development environment.