EXCEL VBA macro
In this chapter, let's learn how to write a simple macro. Let's take a step-by-step.
1th step: First, let's be able to excel20xx ' develop ' menu. Do the same, click File >> Option.
2nd step: Click on the Customize Ribbon tab and select "Developer", then click "OK".
3rd step: The "Developer" Ribbon appears in the menu bar.
4th step: Click the "Visual Basic" button to open the VBA editor.
5th step: Now, let's start the script by adding a button. Click "Insert" >> Select "button".
6th step: Perform a right-click and select "Properties".
7th step. Edit the name and title as shown below.
8th step: Now, double-click the button, as shown in the outline of the sub-procedure will be displayed.
9th step: Let's start by simply adding a message encoding.
Private Sub Say_helloworld_click () MsgBox "Hi" End Sub
10th step: Now you can click the button to perform the sub-procedure. The output of the sub-procedure is shown below. We will demonstrate further chapters using a simple button, from step #1-10 has been explained to. Therefore, it is important to thoroughly understand the future content of this chapter.
1.VBA Tutorial VBA Excel macro