ScholarLens Back to search
2004•Journal of Sichuan Normal UniversityRequires access

VBA Program Design in Excel

Xiaoping Yang

Open publisher page 4 citations

Abstract

Many users like to use Excel for data management. However, if they only use Excel menu order, users will find that many functions can't be realized. This article deals with some knowledge about VBA and the relation between Excel macro and VBA as well as the question by using VBA program to further develop Excel. The two examples in this article are all derived from practice and are of more practical significance.

About this research paper

What this paper is about

Many users like to use Excel for data management. However, if they only use Excel menu order, users will find that many functions can't be realized. This article deals with some knowledge about VBA and the relation between Excel macro and VBA as well as the question by using VBA program to further develop Excel. The two examples in this article are all derived from practice and are of more practical significance.

Why it matters

OpenAlex reports 4 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Many users like to use Excel for data management. However, if they only use Excel menu order, users will find that many functions can't be realized. This article deals with some knowledge about VBA and the relation between Excel macro and VBA as well as the question by using VBA program to further develop Excel. The two examples in this article are all derived from practice and are of more practical significance.

Key concepts: Visual Basic for Applications, Computer science, Macro, Relation (database), Ms excel, Software engineering, Programming language, Database

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
VBA Program Design in Excel — Research Paper | ScholarLens